agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Amit Kapila <akapila@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Doc: Clarify that publication exclusions track table identity.
Date: Thu, 18 Jun 2026 02:33:26 +0000
Message-ID: <E1wa2ZJ-000nw5-2u@gemulon.postgresql.org> (raw)
Doc: Clarify that publication exclusions track table identity.
The EXCEPT clause of a FOR ALL TABLES publication tracks each excluded
table by its identity rather than by name. As a result, renaming a table
or moving it to another schema with ALTER TABLE ... SET SCHEMA leaves the
exclusion in place, and the table stays excluded from the publication.
This behavior was not previously documented and could surprise users who
might reasonably expect a schema-qualified exclusion to apply only while
the table remains in that schema. Add a note to CREATE PUBLICATION to make
the behavior explicit.
Author: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAHut+PvQ5BqnawCQd6r1tqqd+iAJC-CuRY8wscuXSrpHGUzofA@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/77b6dd909252e3a6352e345788a925d3e4768cda
Modified Files
--------------
doc/src/sgml/ref/create_publication.sgml | 6 ++++++
1 file changed, 6 insertions(+)
Message-ID: <E1wa2ZJ-000nw5-2u@gemulon.postgresql.org>
Permalink: ../E1wa2ZJ-000nw5-2u@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1wa2ZJ-000nw5-2u@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: akapila@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Doc: Clarify that publication exclusions track table identity.
In-Reply-To: <E1wa2ZJ-000nw5-2u@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox