Re: Support EXCEPT for TABLES IN SCHEMA publications

On Mon, 17 Aug 2026 at 09:32, shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> These are very simple scenarios which I tested multiple times. These
> scenarios produced an error in the previous version; see:

Sorry for mentioning the wrong test. There is only one issue, here are
the steps for the same with v25 version:
create schema pub_test;
create table pub_test.testpub_tbl_s1(c1 int);
CREATE PUBLICATION testpub_xwire FOR TABLES IN SCHEMA pub_test EXCEPT
(TABLE pub_test.testpub_tbl_s1);
-- publication ends up empty
ALTER PUBLICATION testpub_xwire SET TABLE pub_test.testpub_tbl_s1;
postgres=# \dRp+ testpub_xwire
Publication testpub_xwire
Owner | All tables | All sequences | Inserts | Updates |
Deletes | Truncates | Generated columns | Via root | Description
----------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+-------------
vigneshwaran_c | f | f | t | t | t
| t | none | f |
(1 row)

postgres=# select * from pg_publication_rel ;
oid | prpubid | prrelid | prexcept | prqual | prattrs
-----+---------+---------+----------+--------+---------
(0 rows)

This has been fixed in the v27 version:
-- Includes the publication table pub_test.testpub_tbl_s1 correctly:
postgres=# \dRp+ testpub_xwire
Publication testpub_xwire
Owner | All tables | All sequences | Inserts | Updates |
Deletes | Truncates | Generated columns | Via root | Description
----------------+------------+---------------+---------+---------+---------+-----------+-------------------+----------+-------------
test | f | f | t | t | t | t
| none | f |
Tables:
"pub_test.testpub_tbl_s1"

postgres=# select * from pg_publication_rel ;
oid | prpubid | prrelid | prexcept | prqual | prattrs
-------+---------+---------+----------+--------+---------
16391 | 16388 | 16385 | f | |
(1 row)

Regards,
Vignesh