0001-doc-change.patch.txt

From 344390a142aafc1c532425d1ae909001eeb17195 Mon Sep 17 00:00:00 2001
From: Shveta Malik <shveta.malik@gmail.com>
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