public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Smith <[email protected]>
To: PostgreSQL Hackers <[email protected]>
Subject: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY
Date: Fri, 17 Apr 2026 09:55:44 +1000
Message-ID: <CAHut+PuVZsm4-Xq4ufDDzJiXbCsSuwO4cJd5Fia3Uc9VBUk5Xw@mail.gmail.com> (raw)
Hi,
Currently, the EXCEPT (TABLE ...) part mentions how 'ONLY' and '*'
work for inheritance tables, but how they have no effect for
partitioned tables [1].
It seems we accidentally missed saying that these also have no effect
for *regular* tables.
PSA: a patch to clarify this.
======
[1] https://www.postgresql.org/docs/devel/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-FOR-EX...
Kind Regards,
Peter Smith.
Fujitsu Australia
Attachments:
[application/octet-stream] v1-0001-Fix-note-about-ONLY-to-mention-regular-tables-too.patch (1.3K, 2-v1-0001-Fix-note-about-ONLY-to-mention-regular-tables-too.patch)
download | inline diff:
From f83baefec49db09cefcbea0c10e6655460e6b55d Mon Sep 17 00:00:00 2001
From: Peter Smith <[email protected]>
Date: Fri, 17 Apr 2026 09:47:57 +1000
Subject: [PATCH v1] Fix note about ONLY to mention regular tables too
---
doc/src/sgml/ref/create_publication.sgml | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml
index 0ac576d3f10..a92457f8bf0 100644
--- a/doc/src/sgml/ref/create_publication.sgml
+++ b/doc/src/sgml/ref/create_publication.sgml
@@ -211,9 +211,11 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
<para>
For partitioned tables, only the root partitioned table may be specified
in <literal>EXCEPT</literal>. Doing so excludes the root table and
- all of its partitions from replication. The optional
- <literal>ONLY</literal> and <literal>*</literal> has no effect for
- partitioned tables.
+ all of its partitions from replication.
+ </para>
+ <para>
+ The optional <literal>ONLY</literal> and <literal>*</literal> have no
+ effect for regular or partitioned tables.
</para>
<para>
There can be a case where a subscription includes multiple publications.
--
2.47.3
view thread (5+ messages) latest in thread
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY
In-Reply-To: <CAHut+PuVZsm4-Xq4ufDDzJiXbCsSuwO4cJd5Fia3Uc9VBUk5Xw@mail.gmail.com>
* 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