diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/publication.out | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/publication.sql | 9 |
2 files changed, 17 insertions, 0 deletions
diff --git a/src/test/regress/expected/publication.out b/src/test/regress/expected/publication.out index b7ce080424f..35595fb1427 100644 --- a/src/test/regress/expected/publication.out +++ b/src/test/regress/expected/publication.out @@ -344,3 +344,11 @@ NOTICE: drop cascades to table pub_test.testpub_nopk RESET SESSION AUTHORIZATION; DROP ROLE regress_publication_user, regress_publication_user2; DROP ROLE regress_publication_user_dummy; +-- stage objects for pg_dump tests +CREATE SCHEMA pubme CREATE TABLE t0 (c int, d int) CREATE TABLE t1 (c int); +SET client_min_messages = 'ERROR'; +CREATE PUBLICATION dump_pub_1ct FOR TABLE ONLY pubme.t0; +CREATE PUBLICATION dump_pub_2ct FOR TABLE ONLY pubme.t0, pubme.t1; +CREATE PUBLICATION dump_pub_all FOR TABLE ONLY pubme.t0, pubme.t1 + WITH (publish_via_partition_root = true); +RESET client_min_messages; diff --git a/src/test/regress/sql/publication.sql b/src/test/regress/sql/publication.sql index 7d5c9373845..021d4e2cb24 100644 --- a/src/test/regress/sql/publication.sql +++ b/src/test/regress/sql/publication.sql @@ -218,3 +218,12 @@ DROP SCHEMA pub_test CASCADE; RESET SESSION AUTHORIZATION; DROP ROLE regress_publication_user, regress_publication_user2; DROP ROLE regress_publication_user_dummy; + +-- stage objects for pg_dump tests +CREATE SCHEMA pubme CREATE TABLE t0 (c int, d int) CREATE TABLE t1 (c int); +SET client_min_messages = 'ERROR'; +CREATE PUBLICATION dump_pub_1ct FOR TABLE ONLY pubme.t0; +CREATE PUBLICATION dump_pub_2ct FOR TABLE ONLY pubme.t0, pubme.t1; +CREATE PUBLICATION dump_pub_all FOR TABLE ONLY pubme.t0, pubme.t1 + WITH (publish_via_partition_root = true); +RESET client_min_messages; |