diff -w -U3 C:/cirrus/src/test/modules/test_pg_dump/expected/test_pg_dump.out C:/cirrus/build/testrun/test_pg_dump/regress/results/test_pg_dump.out --- C:/cirrus/src/test/modules/test_pg_dump/expected/test_pg_dump.out 2024-04-30 06:16:56.555839700 +0000 +++ C:/cirrus/build/testrun/test_pg_dump/regress/results/test_pg_dump.out 2024-04-30 06:23:32.456421100 +0000 @@ -75,64 +75,64 @@ aclexplode(s.initprivs) a; obj | grantor | grantee | privilege_type | is_grantable ----------------------------------------------------+----------+------------------------+----------------+-------------- - column col1 of table regress_pg_dump_table | postgres | - | SELECT | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | postgres | EXECUTE | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | regress_dump_test_role | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | postgres | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | regress_dump_test_role | EXECUTE | f - function wgo_then_no_access() | postgres | - | EXECUTE | f - function wgo_then_no_access() | postgres | postgres | EXECUTE | f - function wgo_then_no_access() | postgres | pg_signal_backend | EXECUTE | t - sequence regress_pg_dump_schema.test_seq | postgres | postgres | SELECT | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | UPDATE | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | USAGE | f - sequence regress_pg_dump_schema.test_seq | postgres | regress_dump_test_role | USAGE | f - sequence regress_pg_dump_seq | postgres | postgres | SELECT | f - sequence regress_pg_dump_seq | postgres | postgres | UPDATE | f - sequence regress_pg_dump_seq | postgres | postgres | USAGE | f - sequence regress_pg_dump_seq | postgres | regress_dump_test_role | USAGE | f - sequence regress_seq_dumpable | postgres | postgres | SELECT | f - sequence regress_seq_dumpable | postgres | postgres | UPDATE | f - sequence regress_seq_dumpable | postgres | postgres | USAGE | f - sequence regress_seq_dumpable | postgres | - | SELECT | f - sequence wgo_then_regular | postgres | postgres | SELECT | f - sequence wgo_then_regular | postgres | postgres | UPDATE | f - sequence wgo_then_regular | postgres | postgres | USAGE | f - sequence wgo_then_regular | postgres | pg_signal_backend | SELECT | f - sequence wgo_then_regular | postgres | pg_signal_backend | UPDATE | t - sequence wgo_then_regular | postgres | pg_signal_backend | USAGE | t - table regress_pg_dump_schema.test_table | postgres | postgres | INSERT | f - table regress_pg_dump_schema.test_table | postgres | postgres | SELECT | f - table regress_pg_dump_schema.test_table | postgres | postgres | UPDATE | f - table regress_pg_dump_schema.test_table | postgres | postgres | DELETE | f - table regress_pg_dump_schema.test_table | postgres | postgres | TRUNCATE | f - table regress_pg_dump_schema.test_table | postgres | postgres | REFERENCES | f - table regress_pg_dump_schema.test_table | postgres | postgres | TRIGGER | f - table regress_pg_dump_schema.test_table | postgres | postgres | MAINTAIN | f - table regress_pg_dump_schema.test_table | postgres | regress_dump_test_role | SELECT | f - table regress_pg_dump_table | postgres | postgres | INSERT | f - table regress_pg_dump_table | postgres | postgres | SELECT | f - table regress_pg_dump_table | postgres | postgres | UPDATE | f - table regress_pg_dump_table | postgres | postgres | DELETE | f - table regress_pg_dump_table | postgres | postgres | TRUNCATE | f - table regress_pg_dump_table | postgres | postgres | REFERENCES | f - table regress_pg_dump_table | postgres | postgres | TRIGGER | f - table regress_pg_dump_table | postgres | postgres | MAINTAIN | f - table regress_pg_dump_table | postgres | regress_dump_test_role | SELECT | f - table regress_table_dumpable | postgres | postgres | INSERT | f - table regress_table_dumpable | postgres | postgres | SELECT | f - table regress_table_dumpable | postgres | postgres | UPDATE | f - table regress_table_dumpable | postgres | postgres | DELETE | f - table regress_table_dumpable | postgres | postgres | TRUNCATE | f - table regress_table_dumpable | postgres | postgres | REFERENCES | f - table regress_table_dumpable | postgres | postgres | TRIGGER | f - table regress_table_dumpable | postgres | postgres | MAINTAIN | f - table regress_table_dumpable | postgres | - | SELECT | f - type regress_pg_dump_schema.test_type | postgres | - | USAGE | f - type regress_pg_dump_schema.test_type | postgres | postgres | USAGE | f - type regress_pg_dump_schema.test_type | postgres | regress_dump_test_role | USAGE | f + column col1 of table regress_pg_dump_table | "SYSTEM" | - | SELECT | f + function regress_pg_dump_schema.test_agg(smallint) | "SYSTEM" | - | EXECUTE | f + function regress_pg_dump_schema.test_agg(smallint) | "SYSTEM" | "SYSTEM" | EXECUTE | f + function regress_pg_dump_schema.test_agg(smallint) | "SYSTEM" | regress_dump_test_role | EXECUTE | f + function regress_pg_dump_schema.test_func() | "SYSTEM" | - | EXECUTE | f + function regress_pg_dump_schema.test_func() | "SYSTEM" | "SYSTEM" | EXECUTE | f + function regress_pg_dump_schema.test_func() | "SYSTEM" | regress_dump_test_role | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | - | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | "SYSTEM" | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | pg_signal_backend | EXECUTE | t + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | regress_dump_test_role | USAGE | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_pg_dump_seq | "SYSTEM" | regress_dump_test_role | USAGE | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_seq_dumpable | "SYSTEM" | - | SELECT | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | SELECT | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | USAGE | f + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | SELECT | f + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | UPDATE | t + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | USAGE | t + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_pg_dump_schema.test_table | "SYSTEM" | regress_dump_test_role | SELECT | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_pg_dump_table | "SYSTEM" | regress_dump_test_role | SELECT | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_table_dumpable | "SYSTEM" | - | SELECT | f + type regress_pg_dump_schema.test_type | "SYSTEM" | - | USAGE | f + type regress_pg_dump_schema.test_type | "SYSTEM" | "SYSTEM" | USAGE | f + type regress_pg_dump_schema.test_type | "SYSTEM" | regress_dump_test_role | USAGE | f (58 rows) SELECT pg_describe_object(classid,objid,objsubid) COLLATE "C" AS obj, @@ -212,57 +212,57 @@ aclexplode(s.initprivs) a; obj | grantor | grantee | privilege_type | is_grantable ----------------------------------------------------+----------+-------------------+----------------+-------------- - column col1 of table regress_pg_dump_table | postgres | - | SELECT | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | postgres | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | postgres | EXECUTE | f - function wgo_then_no_access() | postgres | - | EXECUTE | f - function wgo_then_no_access() | postgres | postgres | EXECUTE | f - function wgo_then_no_access() | postgres | pg_signal_backend | EXECUTE | t - sequence regress_pg_dump_schema.test_seq | postgres | postgres | SELECT | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | UPDATE | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | USAGE | f - sequence regress_pg_dump_seq | postgres | postgres | SELECT | f - sequence regress_pg_dump_seq | postgres | postgres | UPDATE | f - sequence regress_pg_dump_seq | postgres | postgres | USAGE | f - sequence regress_seq_dumpable | postgres | postgres | SELECT | f - sequence regress_seq_dumpable | postgres | postgres | UPDATE | f - sequence regress_seq_dumpable | postgres | postgres | USAGE | f - sequence regress_seq_dumpable | postgres | - | SELECT | f - sequence wgo_then_regular | postgres | postgres | SELECT | f - sequence wgo_then_regular | postgres | postgres | UPDATE | f - sequence wgo_then_regular | postgres | postgres | USAGE | f - sequence wgo_then_regular | postgres | pg_signal_backend | SELECT | f - sequence wgo_then_regular | postgres | pg_signal_backend | UPDATE | t - sequence wgo_then_regular | postgres | pg_signal_backend | USAGE | t - table regress_pg_dump_schema.test_table | postgres | postgres | INSERT | f - table regress_pg_dump_schema.test_table | postgres | postgres | SELECT | f - table regress_pg_dump_schema.test_table | postgres | postgres | UPDATE | f - table regress_pg_dump_schema.test_table | postgres | postgres | DELETE | f - table regress_pg_dump_schema.test_table | postgres | postgres | TRUNCATE | f - table regress_pg_dump_schema.test_table | postgres | postgres | REFERENCES | f - table regress_pg_dump_schema.test_table | postgres | postgres | TRIGGER | f - table regress_pg_dump_schema.test_table | postgres | postgres | MAINTAIN | f - table regress_pg_dump_table | postgres | postgres | INSERT | f - table regress_pg_dump_table | postgres | postgres | SELECT | f - table regress_pg_dump_table | postgres | postgres | UPDATE | f - table regress_pg_dump_table | postgres | postgres | DELETE | f - table regress_pg_dump_table | postgres | postgres | TRUNCATE | f - table regress_pg_dump_table | postgres | postgres | REFERENCES | f - table regress_pg_dump_table | postgres | postgres | TRIGGER | f - table regress_pg_dump_table | postgres | postgres | MAINTAIN | f - table regress_table_dumpable | postgres | postgres | INSERT | f - table regress_table_dumpable | postgres | postgres | SELECT | f - table regress_table_dumpable | postgres | postgres | UPDATE | f - table regress_table_dumpable | postgres | postgres | DELETE | f - table regress_table_dumpable | postgres | postgres | TRUNCATE | f - table regress_table_dumpable | postgres | postgres | REFERENCES | f - table regress_table_dumpable | postgres | postgres | TRIGGER | f - table regress_table_dumpable | postgres | postgres | MAINTAIN | f - table regress_table_dumpable | postgres | - | SELECT | f - type regress_pg_dump_schema.test_type | postgres | - | USAGE | f - type regress_pg_dump_schema.test_type | postgres | postgres | USAGE | f + column col1 of table regress_pg_dump_table | "SYSTEM" | - | SELECT | f + function regress_pg_dump_schema.test_agg(smallint) | "SYSTEM" | - | EXECUTE | f + function regress_pg_dump_schema.test_agg(smallint) | "SYSTEM" | "SYSTEM" | EXECUTE | f + function regress_pg_dump_schema.test_func() | "SYSTEM" | - | EXECUTE | f + function regress_pg_dump_schema.test_func() | "SYSTEM" | "SYSTEM" | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | - | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | "SYSTEM" | EXECUTE | f + function wgo_then_no_access() | "SYSTEM" | pg_signal_backend | EXECUTE | t + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_pg_dump_schema.test_seq | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_pg_dump_seq | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | SELECT | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence regress_seq_dumpable | "SYSTEM" | "SYSTEM" | USAGE | f + sequence regress_seq_dumpable | "SYSTEM" | - | SELECT | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | SELECT | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | UPDATE | f + sequence wgo_then_regular | "SYSTEM" | "SYSTEM" | USAGE | f + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | SELECT | f + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | UPDATE | t + sequence wgo_then_regular | "SYSTEM" | pg_signal_backend | USAGE | t + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_pg_dump_schema.test_table | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_pg_dump_table | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | INSERT | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | SELECT | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | UPDATE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | DELETE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | TRUNCATE | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | REFERENCES | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | TRIGGER | f + table regress_table_dumpable | "SYSTEM" | "SYSTEM" | MAINTAIN | f + table regress_table_dumpable | "SYSTEM" | - | SELECT | f + type regress_pg_dump_schema.test_type | "SYSTEM" | - | USAGE | f + type regress_pg_dump_schema.test_type | "SYSTEM" | "SYSTEM" | USAGE | f (51 rows) SELECT pg_describe_object(classid,objid,objsubid) COLLATE "C" AS obj,