v2-0001-DOCS-clarify-behaviour-when-EXCEPT-tables-are-ren.patch

application/octet-stream

Filename: v2-0001-DOCS-clarify-behaviour-when-EXCEPT-tables-are-ren.patch
Type: application/octet-stream
Part: 0
Message: Re: DOCS - Clarify behaviour when EXCEPT tables are moved/renamed

Patch

Format: format-patch
Series: patch v2-0001
Subject: DOCS - clarify behaviour when EXCEPT tables are renamed/moved
File+
doc/src/sgml/ref/create_publication.sgml 6 0
From 31f78ca1b858d7c1a3d6265c82608460173ca139 Mon Sep 17 00:00:00 2001
From: Peter Smith <peter.b.smith@fujitsu.com>
Date: Thu, 18 Jun 2026 08:41:35 +1000
Subject: [PATCH v2] DOCS - clarify behaviour when EXCEPT tables are
 renamed/moved

---
 doc/src/sgml/ref/create_publication.sgml | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml
index f82d640e6ca..85cfcaddafa 100644
--- a/doc/src/sgml/ref/create_publication.sgml
+++ b/doc/src/sgml/ref/create_publication.sgml
@@ -200,6 +200,12 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
       This clause specifies a list of tables to be excluded from the
       publication.
      </para>
+     <para>
+      Once a table is excluded, the exclusion applies to that table
+      regardless of its name or schema. Renaming the table or moving it to
+      another schema using <command>ALTER TABLE ... SET SCHEMA</command> does
+      not remove the exclusion.
+     </para>
      <para>
       For inherited tables, if <literal>ONLY</literal> is specified before the
       table name, only that table is excluded from the publication. If
-- 
2.47.3