Re: Support EXCEPT for ALL SEQUENCES publications
vignesh C <vignesh21@gmail.com>
From: vignesh C <vignesh21@gmail.com>
To: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-13T04:22:00Z
Lists: pgsql-hackers
On Sun, 12 Apr 2026 at 00:32, Shlok Kyal <shlok.kyal.oss@gmail.com> wrote: > Hi Vignesh and Shveta, > > Thanks for reviewing the patches. > I have addressed the comments and attached the updated patch. Few comments for the first patch: 1) I felt these also could be moved to first patch: - * Gets list of table oids that were specified in the EXCEPT clause for a + * Gets list of relation oids that were specified in the EXCEPT clause for a 2) Similarly here too: - * The returned tables are locked in ShareUpdateExclusiveLock mode in order to - * add them to a publication. + * The returned relations are locked in ShareUpdateExclusiveLock mode in order + * to add them to a publication. 3) Similarly here too: /* - * Add listed tables to the publication. + * Add listed relations to the publication. */ 4) Similarly here too: - /* Must be owner of the table or superuser. */ + /* Must be owner of the relation or superuser. */ 5) Ordering issue here, PublicationRelation should be after PublicationRelKind: diff --git a/src/tools/pgindent/typedefs.list b/src/tools/pgindent/typedefs.list index ea95e7984bc..ff20501223c 100644 --- a/src/tools/pgindent/typedefs.list +++ b/src/tools/pgindent/typedefs.list @@ -2461,7 +2461,7 @@ PublicationPartOpt PublicationRelInfo PublicationRelKind PublicationSchemaInfo -PublicationTable +PublicationRelation Regards, Vignesh
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