diff options
| author | Noah Misch <noah@leadboat.com> | 2021-06-28 18:34:55 -0700 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2021-06-28 18:34:55 -0700 |
| commit | a7a7be1f2fa6b9f0f48e69f12256d8f588af729b (patch) | |
| tree | e99220900982ed7ffa06985ddbcbf1a125aad926 /src/test | |
| parent | 14b2ffaf7ffdd199937e8bcba8b459da5491bcb6 (diff) | |
Dump public schema ownership and security labels.
As a side effect, this corrects dumps of public schema ACLs in databases
where the DBA dropped and recreated that schema.
Reviewed by Asif Rehman.
Discussion: https://postgr.es/m/20201229134924.GA1431748@rfd.leadboat.com
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/modules/test_pg_dump/t/001_base.pl | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/modules/test_pg_dump/t/001_base.pl b/src/test/modules/test_pg_dump/t/001_base.pl index 4baca365c64..8511da5169b 100644 --- a/src/test/modules/test_pg_dump/t/001_base.pl +++ b/src/test/modules/test_pg_dump/t/001_base.pl @@ -318,6 +318,14 @@ my %tests = ( like => { pg_dumpall_globals => 1, }, }, + 'CREATE SCHEMA public' => { + regexp => qr/^CREATE SCHEMA public;/m, + like => { + extension_schema => 1, + without_extension_explicit_schema => 1, + }, + }, + 'CREATE SEQUENCE regress_pg_dump_table_col1_seq' => { regexp => qr/^ \QCREATE SEQUENCE public.regress_pg_dump_table_col1_seq\E |