Horton
Menu

Re: Support EXCEPT for ALL SEQUENCES publications

solai v <solai.cdac@gmail.com>

View thread
From: solai v <solai.cdac@gmail.com>
To: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>, shveta malik <shveta.malik@gmail.com>, vignesh C <vignesh21@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-23T11:39:10Z
Lists: pgsql-hackers 
Hi Shlok,

I applied the latest v11 patch series and tested it on my setup.
I verified the new EXCEPT support for both CREATE PUBLICATION and
ALTER PUBLICATION with FOR ALL SEQUENCES. I tested single and multiple
sequence exclusions, replacing and clearing exclusion lists, and
checked the output using \dRp+.
I also tried a number of edge cases, including non-existent sequences,
temporary sequences, unlogged sequences, duplicate entries in the
EXCEPT list, schema-qualified sequence names, and sequences with the
same name in different schemas. All of these behaved as expected.
In addition, I verified that pg_dump correctly preserves the EXCEPT
(SEQUENCE...)clause and that psql tab completion suggests sequence
names correctly for both CREATE PUBLICATION and ALTER PUBLICATION.
Overall, the patch applied cleanly, built successfully, and all the
test cases I tried worked as expected. I didn't notice any issues
during testing.

Regards,
solai

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Doc: Clarify that publication exclusions track table identity.

  2. Use schema-qualified names in EXCEPT clause error messages.

  3. psql: Improve describe footer titles for publications.

  4. Improve various new-to-v19 appendStringInfo calls