| 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 |
| 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 |