On Mon, Mar 9, 2026 at 8:22 AM vignesh C <[email protected]> wrote: > > > The attached v59 patch has the changes to update the syntax accordingly. >
Thanks for the patch. I have attached my suggestion for doc change, please take it if you find it appropriate. Reviewing further. thanks Shveta
From 344390a142aafc1c532425d1ae909001eeb17195 Mon Sep 17 00:00:00 2001 From: Shveta Malik <[email protected]> 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 <replaceable class="parameter">name</replaceable> RENAME TO <r </para> <para> - The first four variants change which tables/exclude tables/schemas are part - of the publication. The <literal>SET ALL TABLES</literal> clause resets the - publication of <literal>FOR ALL TABLES</literal> publication. If - <literal>EXCEPT TABLE</literal> is provided, the current except table list is - replaced by the specified except tables. If <literal>EXCEPT TABLE</literal> - is omitted, all existing except tables are removed. The - <literal>SET</literal> 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 <literal>ADD</literal> and - <literal>DROP</literal> 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 + <literal>SET ALL TABLES</literal> clause is used to update the + <literal>EXCEPT TABLE</literal> list of a <literal>FOR ALL TABLES</literal> + publication. If <literal>EXCEPT TABLE</literal> is specified with a list of + tables, the existing except table list is replaced with the specified tables. + If <literal>EXCEPT TABLE</literal> is omitted, the except-table list is cleared. + The <literal>SET</literal> clause, when used with a publication defined with + <literal>FOR TABLE</literal> or <literal>FOR TABLES IN SCHEMA</literal>, + 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 <literal>ADD</literal> and <literal>DROP</literal> + 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 <link linkend="sql-altersubscription-params-refresh-publication"> <literal>ALTER SUBSCRIPTION ... REFRESH PUBLICATION</literal></link> action on the - subscribing side in order to become effective. Note also that + subscribing side in order to become effective. Note also that <literal>DROP TABLES IN SCHEMA</literal> will not drop any schema tables that were specified using <link linkend="sql-createpublication-params-for-table"><literal>FOR TABLE</literal></link>/ -- 2.34.1
