diff -U3 /Users/test/Work/postgrespro/src/test/modules/test_pg_dump/expected/test_pg_dump.out /Users/test/Work/postgrespro/build/testrun/test_pg_dump-running/regress/results/test_pg_dump.out --- /Users/test/Work/postgrespro/src/test/modules/test_pg_dump/expected/test_pg_dump.out 2024-09-12 15:02:26.345434331 +0700 +++ /Users/test/Work/postgrespro/build/testrun/test_pg_dump-running/regress/results/test_pg_dump.out 2024-09-12 15:42:09.341520173 +0700 @@ -145,29 +145,69 @@ ----------------------------------------------------+-----------------------------+--------- column c1 of foreign table ft1 | role regress_dump_test_role | a column c1 of table test_pg_dump_t1 | role regress_dump_test_role | a + column col1 of table regress_pg_dump_table | role test | i + extension test_pg_dump | role test | o foreign table ft1 | role regress_dump_test_role | a + foreign table ft1 | role test | o foreign-data wrapper dummy | role regress_dump_test_role | a + foreign-data wrapper dummy | role test | o + function casttesttype_in(cstring) | role test | o + function casttesttype_out(casttesttype) | role test | o + function newavg(integer) | role test | o function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | a + function regress_pg_dump_schema.test_agg(smallint) | role test | i function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | i + function regress_pg_dump_schema.test_agg(smallint) | role test | o function regress_pg_dump_schema.test_func() | role regress_dump_test_role | a function regress_pg_dump_schema.test_func() | role regress_dump_test_role | i + function regress_pg_dump_schema.test_func() | role test | i + function regress_pg_dump_schema.test_func() | role test | o function test_pg_dump(integer) | role regress_dump_test_role | a + function test_pg_dump(integer) | role test | o + function wgo_then_no_access() | role test | i + function wgo_then_no_access() | role test | o materialized view test_pg_dump_mv1 | role regress_dump_test_role | a + materialized view test_pg_dump_mv1 | role test | o + operator ====(integer,integer) | role test | o + schema regress_pg_dump_schema | role test | o schema test_pg_dump_s1 | role regress_dump_test_role | a + schema test_pg_dump_s1 | role test | o sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | a sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | i + sequence regress_pg_dump_schema.test_seq | role test | i + sequence regress_pg_dump_schema.test_seq | role test | o sequence regress_pg_dump_seq | role regress_dump_test_role | a + sequence regress_pg_dump_seq | role test | i sequence regress_pg_dump_seq | role regress_dump_test_role | i + sequence regress_pg_dump_seq | role test | o + sequence regress_pg_dump_table_col1_seq | role test | o + sequence regress_seq_dumpable | role test | i + sequence regress_seq_dumpable | role test | o + sequence wgo_then_regular | role test | i + sequence wgo_then_regular | role test | o server s0 | role regress_dump_test_role | a + server s0 | role test | o table regress_pg_dump_schema.test_table | role regress_dump_test_role | a + table regress_pg_dump_schema.test_table | role test | i table regress_pg_dump_schema.test_table | role regress_dump_test_role | i + table regress_pg_dump_schema.test_table | role test | o table regress_pg_dump_table | role regress_dump_test_role | a table regress_pg_dump_table | role regress_dump_test_role | i + table regress_pg_dump_table | role test | i + table regress_pg_dump_table | role test | o + table regress_table_dumpable | role test | i + table regress_table_dumpable | role test | o + table test_pg_dump_t1 | role test | o + type casttesttype | role test | o type regress_pg_dump_schema.test_type | role regress_dump_test_role | a + type regress_pg_dump_schema.test_type | role test | i type regress_pg_dump_schema.test_type | role regress_dump_test_role | i + type regress_pg_dump_schema.test_type | role test | o type test_pg_dump_e1 | role regress_dump_test_role | a + type test_pg_dump_e1 | role test | o view test_pg_dump_v1 | role regress_dump_test_role | a -(24 rows) + view test_pg_dump_v1 | role test | o +(64 rows) ALTER EXTENSION test_pg_dump ADD ACCESS METHOD gist2; ALTER EXTENSION test_pg_dump ADD AGGREGATE newavg(int4); @@ -271,9 +311,49 @@ FROM pg_shdepend JOIN pg_database d ON dbid = d.oid WHERE d.datname = current_database() ORDER BY 1, 3; - obj | refobj | deptype ------+--------+--------- -(0 rows) + obj | refobj | deptype +----------------------------------------------------+-----------+--------- + column col1 of table regress_pg_dump_table | role test | i + extension test_pg_dump | role test | o + foreign table ft1 | role test | o + foreign-data wrapper dummy | role test | o + function casttesttype_in(cstring) | role test | o + function casttesttype_out(casttesttype) | role test | o + function newavg(integer) | role test | o + function regress_pg_dump_schema.test_agg(smallint) | role test | i + function regress_pg_dump_schema.test_agg(smallint) | role test | o + function regress_pg_dump_schema.test_func() | role test | i + function regress_pg_dump_schema.test_func() | role test | o + function test_pg_dump(integer) | role test | o + function wgo_then_no_access() | role test | i + function wgo_then_no_access() | role test | o + materialized view test_pg_dump_mv1 | role test | o + operator ====(integer,integer) | role test | o + schema regress_pg_dump_schema | role test | o + schema test_pg_dump_s1 | role test | o + sequence regress_pg_dump_schema.test_seq | role test | i + sequence regress_pg_dump_schema.test_seq | role test | o + sequence regress_pg_dump_seq | role test | i + sequence regress_pg_dump_seq | role test | o + sequence regress_pg_dump_table_col1_seq | role test | o + sequence regress_seq_dumpable | role test | i + sequence regress_seq_dumpable | role test | o + sequence wgo_then_regular | role test | i + sequence wgo_then_regular | role test | o + server s0 | role test | o + table regress_pg_dump_schema.test_table | role test | i + table regress_pg_dump_schema.test_table | role test | o + table regress_pg_dump_table | role test | i + table regress_pg_dump_table | role test | o + table regress_table_dumpable | role test | i + table regress_table_dumpable | role test | o + table test_pg_dump_t1 | role test | o + type casttesttype | role test | o + type regress_pg_dump_schema.test_type | role test | i + type regress_pg_dump_schema.test_type | role test | o + type test_pg_dump_e1 | role test | o + view test_pg_dump_v1 | role test | o +(40 rows) DROP ROLE regress_dump_test_role; DROP EXTENSION test_pg_dump; @@ -371,6 +451,11 @@ ----------------------------------------------------+------------------------------+--------- column col1 of table regress_pg_dump_table | role regress_dump_test_super | i extension test_pg_dump | role regress_dump_test_super | o + foreign table ft1 | role test | o + foreign-data wrapper dummy | role test | o + function casttesttype_in(cstring) | role test | o + function casttesttype_out(casttesttype) | role test | o + function newavg(integer) | role test | o function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | a function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | i function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_super | i @@ -379,9 +464,13 @@ function regress_pg_dump_schema.test_func() | role regress_dump_test_role | i function regress_pg_dump_schema.test_func() | role regress_dump_test_super | i function regress_pg_dump_schema.test_func() | role regress_dump_test_super | o + function test_pg_dump(integer) | role test | o function wgo_then_no_access() | role regress_dump_test_super | i function wgo_then_no_access() | role regress_dump_test_super | o + materialized view test_pg_dump_mv1 | role test | o + operator ====(integer,integer) | role test | o schema regress_pg_dump_schema | role regress_dump_test_super | o + schema test_pg_dump_s1 | role test | o sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | a sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | i sequence regress_pg_dump_schema.test_seq | role regress_dump_test_super | i @@ -395,6 +484,7 @@ sequence regress_seq_dumpable | role regress_dump_test_super | o sequence wgo_then_regular | role regress_dump_test_super | i sequence wgo_then_regular | role regress_dump_test_super | o + server s0 | role test | o table regress_pg_dump_schema.test_table | role regress_dump_test_role | a table regress_pg_dump_schema.test_table | role regress_dump_test_role | i table regress_pg_dump_schema.test_table | role regress_dump_test_super | i @@ -405,11 +495,15 @@ table regress_pg_dump_table | role regress_dump_test_super | o table regress_table_dumpable | role regress_dump_test_super | i table regress_table_dumpable | role regress_dump_test_super | o + table test_pg_dump_t1 | role test | o + type casttesttype | role test | o type regress_pg_dump_schema.test_type | role regress_dump_test_role | a type regress_pg_dump_schema.test_type | role regress_dump_test_role | i type regress_pg_dump_schema.test_type | role regress_dump_test_super | i type regress_pg_dump_schema.test_type | role regress_dump_test_super | o -(40 rows) + type test_pg_dump_e1 | role test | o + view test_pg_dump_v1 | role test | o +(54 rows) REASSIGN OWNED BY regress_dump_test_super TO CURRENT_ROLE; -- Substitute for current user's name to keep test output consistent @@ -493,21 +587,61 @@ ORDER BY 1, 2, 3; obj | refobj | deptype ----------------------------------------------------+-----------------------------+--------- + column col1 of table regress_pg_dump_table | role test | i + extension test_pg_dump | role test | o + foreign table ft1 | role test | o + foreign-data wrapper dummy | role test | o + function casttesttype_in(cstring) | role test | o + function casttesttype_out(casttesttype) | role test | o + function newavg(integer) | role test | o + function regress_pg_dump_schema.test_agg(smallint) | role test | i + function regress_pg_dump_schema.test_agg(smallint) | role test | o function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | a function regress_pg_dump_schema.test_agg(smallint) | role regress_dump_test_role | i + function regress_pg_dump_schema.test_func() | role test | i + function regress_pg_dump_schema.test_func() | role test | o function regress_pg_dump_schema.test_func() | role regress_dump_test_role | a function regress_pg_dump_schema.test_func() | role regress_dump_test_role | i + function test_pg_dump(integer) | role test | o + function wgo_then_no_access() | role test | i + function wgo_then_no_access() | role test | o + materialized view test_pg_dump_mv1 | role test | o + operator ====(integer,integer) | role test | o + schema regress_pg_dump_schema | role test | o + schema test_pg_dump_s1 | role test | o + sequence regress_pg_dump_schema.test_seq | role test | i + sequence regress_pg_dump_schema.test_seq | role test | o sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | a sequence regress_pg_dump_schema.test_seq | role regress_dump_test_role | i + sequence regress_pg_dump_seq | role test | i + sequence regress_pg_dump_seq | role test | o sequence regress_pg_dump_seq | role regress_dump_test_role | a sequence regress_pg_dump_seq | role regress_dump_test_role | i + sequence regress_pg_dump_table_col1_seq | role test | o + sequence regress_seq_dumpable | role test | i + sequence regress_seq_dumpable | role test | o + sequence wgo_then_regular | role test | i + sequence wgo_then_regular | role test | o + server s0 | role test | o + table regress_pg_dump_schema.test_table | role test | i + table regress_pg_dump_schema.test_table | role test | o table regress_pg_dump_schema.test_table | role regress_dump_test_role | a table regress_pg_dump_schema.test_table | role regress_dump_test_role | i + table regress_pg_dump_table | role test | i + table regress_pg_dump_table | role test | o table regress_pg_dump_table | role regress_dump_test_role | a table regress_pg_dump_table | role regress_dump_test_role | i + table regress_table_dumpable | role test | i + table regress_table_dumpable | role test | o + table test_pg_dump_t1 | role test | o + type casttesttype | role test | o + type regress_pg_dump_schema.test_type | role test | i + type regress_pg_dump_schema.test_type | role test | o type regress_pg_dump_schema.test_type | role regress_dump_test_role | a type regress_pg_dump_schema.test_type | role regress_dump_test_role | i -(14 rows) + type test_pg_dump_e1 | role test | o + view test_pg_dump_v1 | role test | o +(54 rows) DROP OWNED BY regress_dump_test_role RESTRICT; -- Substitute for current user's name to keep test output consistent @@ -582,9 +716,49 @@ FROM pg_shdepend JOIN pg_database d ON dbid = d.oid WHERE d.datname = current_database() ORDER BY 1, 2, 3; - obj | refobj | deptype ------+--------+--------- -(0 rows) + obj | refobj | deptype +----------------------------------------------------+-----------+--------- + column col1 of table regress_pg_dump_table | role test | i + extension test_pg_dump | role test | o + foreign table ft1 | role test | o + foreign-data wrapper dummy | role test | o + function casttesttype_in(cstring) | role test | o + function casttesttype_out(casttesttype) | role test | o + function newavg(integer) | role test | o + function regress_pg_dump_schema.test_agg(smallint) | role test | i + function regress_pg_dump_schema.test_agg(smallint) | role test | o + function regress_pg_dump_schema.test_func() | role test | i + function regress_pg_dump_schema.test_func() | role test | o + function test_pg_dump(integer) | role test | o + function wgo_then_no_access() | role test | i + function wgo_then_no_access() | role test | o + materialized view test_pg_dump_mv1 | role test | o + operator ====(integer,integer) | role test | o + schema regress_pg_dump_schema | role test | o + schema test_pg_dump_s1 | role test | o + sequence regress_pg_dump_schema.test_seq | role test | i + sequence regress_pg_dump_schema.test_seq | role test | o + sequence regress_pg_dump_seq | role test | i + sequence regress_pg_dump_seq | role test | o + sequence regress_pg_dump_table_col1_seq | role test | o + sequence regress_seq_dumpable | role test | i + sequence regress_seq_dumpable | role test | o + sequence wgo_then_regular | role test | i + sequence wgo_then_regular | role test | o + server s0 | role test | o + table regress_pg_dump_schema.test_table | role test | i + table regress_pg_dump_schema.test_table | role test | o + table regress_pg_dump_table | role test | i + table regress_pg_dump_table | role test | o + table regress_table_dumpable | role test | i + table regress_table_dumpable | role test | o + table test_pg_dump_t1 | role test | o + type casttesttype | role test | o + type regress_pg_dump_schema.test_type | role test | i + type regress_pg_dump_schema.test_type | role test | o + type test_pg_dump_e1 | role test | o + view test_pg_dump_v1 | role test | o +(40 rows) DROP ROLE regress_dump_test_super; DROP ROLE regress_dump_test_role;