diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/publication.out | 83 | ||||
| -rw-r--r-- | src/test/regress/sql/publication.sql | 1 |
2 files changed, 46 insertions, 38 deletions
diff --git a/src/test/regress/expected/publication.out b/src/test/regress/expected/publication.out index e81919fd8cb..50592c63a9b 100644 --- a/src/test/regress/expected/publication.out +++ b/src/test/regress/expected/publication.out @@ -21,20 +21,20 @@ ERROR: unrecognized publication parameter: foo CREATE PUBLICATION testpub_xxx WITH (publish = 'cluster, vacuum'); ERROR: unrecognized "publish" value: "cluster" \dRp - List of publications - Name | Owner | Inserts | Updates | Deletes ---------------------+--------------------------+---------+---------+--------- - testpib_ins_trunct | regress_publication_user | t | f | f - testpub_default | regress_publication_user | f | t | f + List of publications + Name | Owner | All tables | Inserts | Updates | Deletes +--------------------+--------------------------+------------+---------+---------+--------- + testpib_ins_trunct | regress_publication_user | f | t | f | f + testpub_default | regress_publication_user | f | f | t | f (2 rows) ALTER PUBLICATION testpub_default SET (publish = 'insert, update, delete'); \dRp - List of publications - Name | Owner | Inserts | Updates | Deletes ---------------------+--------------------------+---------+---------+--------- - testpib_ins_trunct | regress_publication_user | t | f | f - testpub_default | regress_publication_user | t | t | t + List of publications + Name | Owner | All tables | Inserts | Updates | Deletes +--------------------+--------------------------+------------+---------+---------+--------- + testpib_ins_trunct | regress_publication_user | f | t | f | f + testpub_default | regress_publication_user | f | t | t | t (2 rows) --- adding tables @@ -75,6 +75,13 @@ Indexes: Publications: "testpub_foralltables" +\dRp+ testpub_foralltables + Publication testpub_foralltables + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + t | t | t | f +(1 row) + DROP TABLE testpub_tbl2; DROP PUBLICATION testpub_foralltables; CREATE TABLE testpub_tbl3 (a int); @@ -82,19 +89,19 @@ CREATE TABLE testpub_tbl3a (b text) INHERITS (testpub_tbl3); CREATE PUBLICATION testpub3 FOR TABLE testpub_tbl3; CREATE PUBLICATION testpub4 FOR TABLE ONLY testpub_tbl3; \dRp+ testpub3 - Publication testpub3 - Inserts | Updates | Deletes ----------+---------+--------- - t | t | t + Publication testpub3 + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + f | t | t | t Tables: "public.testpub_tbl3" "public.testpub_tbl3a" \dRp+ testpub4 - Publication testpub4 - Inserts | Updates | Deletes ----------+---------+--------- - t | t | t + Publication testpub4 + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + f | t | t | t Tables: "public.testpub_tbl3" @@ -112,10 +119,10 @@ ERROR: relation "testpub_tbl1" is already member of publication "testpub_fortbl CREATE PUBLICATION testpub_fortbl FOR TABLE testpub_tbl1; ERROR: publication "testpub_fortbl" already exists \dRp+ testpub_fortbl - Publication testpub_fortbl - Inserts | Updates | Deletes ----------+---------+--------- - t | t | t + Publication testpub_fortbl + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + f | t | t | t Tables: "pub_test.testpub_nopk" "public.testpub_tbl1" @@ -158,10 +165,10 @@ Publications: "testpub_fortbl" \dRp+ testpub_default - Publication testpub_default - Inserts | Updates | Deletes ----------+---------+--------- - t | t | t + Publication testpub_default + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + f | t | t | t Tables: "pub_test.testpub_nopk" "public.testpub_tbl1" @@ -203,10 +210,10 @@ DROP TABLE testpub_parted; DROP VIEW testpub_view; DROP TABLE testpub_tbl1; \dRp+ testpub_default - Publication testpub_default - Inserts | Updates | Deletes ----------+---------+--------- - t | t | t + Publication testpub_default + All tables | Inserts | Updates | Deletes +------------+---------+---------+--------- + f | t | t | t (1 row) -- fail - must be owner of publication @@ -216,20 +223,20 @@ ERROR: must be owner of publication testpub_default RESET ROLE; ALTER PUBLICATION testpub_default RENAME TO testpub_foo; \dRp testpub_foo - List of publications - Name | Owner | Inserts | Updates | Deletes --------------+--------------------------+---------+---------+--------- - testpub_foo | regress_publication_user | t | t | t + List of publications + Name | Owner | All tables | Inserts | Updates | Deletes +-------------+--------------------------+------------+---------+---------+--------- + testpub_foo | regress_publication_user | f | t | t | t (1 row) -- rename back to keep the rest simple ALTER PUBLICATION testpub_foo RENAME TO testpub_default; ALTER PUBLICATION testpub_default OWNER TO regress_publication_user2; \dRp testpub_default - List of publications - Name | Owner | Inserts | Updates | Deletes ------------------+---------------------------+---------+---------+--------- - testpub_default | regress_publication_user2 | t | t | t + List of publications + Name | Owner | All tables | Inserts | Updates | Deletes +-----------------+---------------------------+------------+---------+---------+--------- + testpub_default | regress_publication_user2 | f | t | t | t (1 row) DROP PUBLICATION testpub_default; diff --git a/src/test/regress/sql/publication.sql b/src/test/regress/sql/publication.sql index cc1f33e72cd..815410b3c5a 100644 --- a/src/test/regress/sql/publication.sql +++ b/src/test/regress/sql/publication.sql @@ -45,6 +45,7 @@ ALTER PUBLICATION testpub_foralltables SET TABLE pub_test.testpub_nopk; SELECT pubname, puballtables FROM pg_publication WHERE pubname = 'testpub_foralltables'; \d+ testpub_tbl2 +\dRp+ testpub_foralltables DROP TABLE testpub_tbl2; DROP PUBLICATION testpub_foralltables; |