diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/publication.out --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-03-01 03:34:31.828891918 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-03-01 03:40:42.581546280 +0000 @@ -243,10 +243,10 @@ -- the optional TABLE keyword. CREATE PUBLICATION testpub_foralltables_excepttable FOR ALL TABLES EXCEPT TABLE (testpub_tbl1, testpub_tbl2); \dRp+ testpub_foralltables_excepttable - Publication testpub_foralltables_excepttable - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub_foralltables_excepttable + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl1" "public.testpub_tbl2" @@ -254,10 +254,10 @@ -- Specify table in the EXCEPT clause of a FOR ALL TABLES publication CREATE PUBLICATION testpub_foralltables_excepttable1 FOR ALL TABLES EXCEPT TABLE (testpub_tbl1); \dRp+ testpub_foralltables_excepttable1 - Publication testpub_foralltables_excepttable1 - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub_foralltables_excepttable1 + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl1" @@ -280,20 +280,20 @@ -- Replace the publication EXCEPT table list with a specific EXCEPT table. ALTER PUBLICATION testpub_foralltables_excepttable SET EXCEPT TABLE testpub_tbl1; \dRp+ testpub_foralltables_excepttable - Publication testpub_foralltables_excepttable - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub_foralltables_excepttable + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl1" -- Drop table from the EXCEPT list of a FOR ALL TABLES publication. ALTER PUBLICATION testpub_foralltables_excepttable DROP EXCEPT TABLE testpub_tbl1; \dRp+ testpub_foralltables_excepttable - Publication testpub_foralltables_excepttable - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub_foralltables_excepttable + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | (1 row) -- fail - Adding EXCEPT table is not supported. @@ -331,10 +331,10 @@ -- List the parent table in the EXCEPT clause (without ONLY or '*') CREATE PUBLICATION testpub5 FOR ALL TABLES EXCEPT TABLE (testpub_tbl_parent); \dRp+ testpub5 - Publication testpub5 - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub5 + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl_child" "public.testpub_tbl_parent" @@ -342,10 +342,10 @@ -- EXCEPT with '*': list the table and all its descendants in the EXCEPT clause CREATE PUBLICATION testpub6 FOR ALL TABLES EXCEPT TABLE (testpub_tbl_parent *); \dRp+ testpub6 - Publication testpub6 - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub6 + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl_child" "public.testpub_tbl_parent" @@ -353,10 +353,10 @@ -- EXCEPT with ONLY: list the table in the EXCEPT clause, but not its descendants CREATE PUBLICATION testpub7 FOR ALL TABLES EXCEPT TABLE (ONLY testpub_tbl_parent); \dRp+ testpub7 - Publication testpub7 - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub7 + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_tbl_parent" @@ -372,10 +372,10 @@ CREATE TABLE testpub_part2 PARTITION OF testpub_root FOR VALUES FROM (100) TO (200); CREATE PUBLICATION testpub8 FOR ALL TABLES EXCEPT TABLE (testpub_root); \dRp+ testpub8; - Publication testpub8 - Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root ---------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+---------- - regress_publication_user | t | f | t | t | t | t | none | f + Publication testpub8 + Owner | All tables | All sequences | Inserts | Updates | Deletes | Truncates | Generated columns | Via root | Description +--------------------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+------------- + regress_publication_user | t | f | t | t | t | t | none | f | Except tables: "public.testpub_root"