Re: DOCS - Add missing EXCEPT parameter description to ALTER PUBLICATION

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Re: DOCS - Add missing EXCEPT parameter description to ALTER PUBLICATION
Date: 2026-06-09 06:41:46
Message-ID: CAHut+Pui8-YTBjiP7SxHN5HebpM-wBKqN4bdEw=_d-oNT2zB2g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Nisha,

Thanks for following-up on this...

The patch LGTM in general, but here are a few comments.

======

1.
+ <varlistentry>
+ <term><literal>EXCEPT</literal></term>
+ <listitem>
+ <para>
+ This clause specifies a list of tables to be excluded from the
+ publication when used with <literal>SET ALL TABLES</literal>. If
+ <literal>EXCEPT</literal> is specified, the existing exclusion list is
+ replaced with the specified tables. If <literal>EXCEPT</literal> is
+ omitted, any existing table exclusions are removed. See
+ <xref linkend="sql-createpublication-params-for-except-table"/> for
+ details.
+ </para>
+ </listitem>
+ </varlistentry>

1a.
I think reversing the first sentence wording makes it simpler.

SUGGESTION
This clause can be used with <literal>SET ALL TABLES</literal> to
specify a list of tables to be excluded from the publication.

~~~

1b.
The term is written differently to how you wrote it in your other thread [1].

Here, you write the term as style #1:
<term><literal>EXCEPT</literal></term>

But, in the other thread you wrote the same term as style #2:
<term><literal>EXCEPT ( <replaceable
class="parameter">except_table_object</replaceable> [, ... ]
)</literal></term>

I am not sure which way is better. If we are eventually going to put
all variations of EXCEPT in the same place then maybe style #1 is
best; OTOH, if we anticipate separate descriptions for the "EXCEPT
(TABLE ...)" and "EXCEPT (SEQUENCE ...)" then maybe style #2 is best.

~~~

1c.
The xref looks a bit strange because it renders like "See EXCEPT for
details", but we are already looking at "EXCEPT", just not the same
one. Perhaps it should be changed so it renders like "See CREATE
PUBLICATION ... EXCEPT for details".

======
[1] https://www.postgresql.org/message-id/flat/CABdArM5sw4Q1ZU8HGdo4BSc1A_%2B8xtUNq17j6wcir%3DyMUy19Cg%40mail.gmail.com

Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-06-09 06:47:06 Re: Avoid orphaned objects dependencies, take 3
Previous Message Nitin Motiani 2026-06-09 06:34:01 Re: Adding pg_dump flag for parallel export to pipes