Improve CREATE/ALTER PUBLICATION syntax for EXCEPT

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Improve CREATE/ALTER PUBLICATION syntax for EXCEPT
Date: 2026-07-22 03:43:14
Message-ID: CAHGQGwEqRP9TwObgdXsMxgF04hPrVH7Y7dAspBHzE=2MYURw1g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

Attached is a small docs patch to improve the syntax and description of
the EXCEPT clause for CREATE/ALTER PUBLICATION.

The current synopsis for EXCEPT is a bit confusing because both the EXCEPT
clause and except_table_object contain repeated lists:

ALL TABLES [ EXCEPT ( except_table_object [, ... ] ) ]
where except_table_object is:
TABLE table_object [, ... ]

The patch simplifies this by describing the syntax directly:

ALL TABLES [ EXCEPT ( TABLE table_object [, [ TABLE ] table_object ] ... ) ]

and removes the separate except_table_object production. I think
this is simpler and easier to understand. Thought?

The patch also updates the ALTER PUBLICATION description. The current
wording says "adding tables/except tables/schemas", but EXCEPT entries
are not added with ADD; they are replaced or cleared with SET ALL TABLES.
The updated text reflects that and also notes that
ALTER SUBSCRIPTION ... REFRESH PUBLICATION is required for such changes
to take effect on subscribers.

It also includes a few minor wording and markup fixes nearby.

Regards,

--
Fujii Masao

Attachment Content-Type Size
v1-0001-doc-Improve-PUBLICATION-.-EXCEPT-documentation.patch application/octet-stream 7.7 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Smith 2026-07-22 04:34:54 Re: Improve CREATE/ALTER PUBLICATION syntax for EXCEPT
Previous Message Michael Paquier 2026-07-21 22:18:33 Re: Add "io worker" as backend_type to the pg_stat_activity documentation