Support EXCEPT for ALL SEQUENCES publications
Shlok Kyal <shlok.kyal.oss@gmail.com>
From: Shlok Kyal <shlok.kyal.oss@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-10T06:08:44Z
Lists: pgsql-hackers
Attachments
- v1-0001-Support-EXCEPT-for-ALL-SEQUENCES-in-CREATE-PUBLIC.patch (application/octet-stream) patch v1-0001
- v1-0002-Support-EXCEPT-for-ALL-SEQUENCES-in-ALTER-PUBLICA.patch (application/octet-stream) patch v1-0002
Hi hackers, Thread [1] introduced support for the EXCEPT clause for publications defined with ALL TABLES. To extend this functionality, as discussed in [2], this patch series adds support for the EXCEPT clause for publications defined with ALL SEQUENCES. The series consists of the following patches: 0001: Support EXCEPT for ALL SEQUENCES in CREATE PUBLICATION This allows excluding specific sequences when using CREATE PUBLICATION ... FOR ALL SEQUENCES. Example: CREATE PUBLICATION pub1 FOR ALL SEQUENCES EXCEPT (SEQUENCE s1, s2); 0002: Support EXCEPT for ALL SEQUENCES in ALTER PUBLICATION This extends ALTER PUBLICATION to manage exclusions for ALL SEQUENCES. Examples: ALTER PUBLICATION pub1 SET ALL SEQUENCES; This clears any existing sequence exclusions. ALTER PUBLICATION pub1 SET ALL SEQUENCES EXCEPT (SEQUENCE s1, s2); This replaces the exclusion list with the specified sequences. Sequences listed in the EXCEPT clause are excluded from the publication and are not replicated to the subscriber. This brings sequence publication behavior in line with the existing support for FOR ALL TABLES ... EXCEPT. [1]: https://www.postgresql.org/message-id/CALDaNm3%3DJrucjhiiwsYQw5-PGtBHFONa6F7hhWCXMsGvh%3DtamA%40mail.gmail.com [2]: https://www.postgresql.org/message-id/CAA4eK1JWz=+-zEhQRszrGEbOzYKReXtsS9hGycWubHV8v2U-QA@mail.gmail.com Thanks, Shlok Kyal
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Doc: Clarify that publication exclusions track table identity.
- 77b6dd909252 19 (unreleased) cited
-
Use schema-qualified names in EXCEPT clause error messages.
- a49b9cfd72d8 19 (unreleased) cited
-
psql: Improve describe footer titles for publications.
- 2e1d4fdb10e6 19 (unreleased) cited
-
Improve various new-to-v19 appendStringInfo calls
- 49ce41810fac 19 (unreleased) cited