From 344390a142aafc1c532425d1ae909001eeb17195 Mon Sep 17 00:00:00 2001 From: Shveta Malik Date: Mon, 9 Mar 2026 09:57:10 +0530 Subject: [PATCH] doc change --- doc/src/sgml/ref/alter_publication.sgml | 29 ++++++++++++++----------- 1 file changed, 16 insertions(+), 13 deletions(-) diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index b48f427a1ba..9f5b1625e1b 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -58,21 +58,24 @@ ALTER PUBLICATION name RENAME TO - The first four variants change which tables/exclude tables/schemas are part - of the publication. The SET ALL TABLES clause resets the - publication of FOR ALL TABLES publication. If - EXCEPT TABLE is provided, the current except table list is - replaced by the specified except tables. If EXCEPT TABLE - is omitted, all existing except tables are removed. The - SET clause will replace the list of tables/schemas in the - publication with the specified list; the existing tables/schemas that were - present in the publication will be removed. The ADD and - DROP clauses will add and remove one or more - tables/schemas from the publication. Note that adding tables/exclude - tables/schemas to a publication that is already subscribed to will require an + The first four variants modify which tables/schemas are included in the + publication, or which tables are excluded from it. The + SET ALL TABLES clause is used to update the + EXCEPT TABLE list of a FOR ALL TABLES + publication. If EXCEPT TABLE is specified with a list of + tables, the existing except table list is replaced with the specified tables. + If EXCEPT TABLE is omitted, the except-table list is cleared. + The SET clause, when used with a publication defined with + FOR TABLE or FOR TABLES IN SCHEMA, + replaces the list of tables/schemas in the publication with the specified + list; the existing tables or schemas that were present in the publication + will be removed. The ADD and DROP + clauses will add and remove one or more tables/schemas from the publication. + Note that adding tables/except tables/schemas to a publication that is + already subscribed to will require an ALTER SUBSCRIPTION ... REFRESH PUBLICATION action on the - subscribing side in order to become effective. Note also that + subscribing side in order to become effective. Note also that DROP TABLES IN SCHEMA will not drop any schema tables that were specified using FOR TABLE/ -- 2.34.1