MIME-Version: 1.0
References: 
 <CAJpy0uB20MhJJEaPJdm31t4fykJ+fChA_76jU2P9HX5knbJvAA@mail.gmail.com>
 <CAD21AoCC8XuwfX62qKBSfHUAoww_XB3_84HjswgL9jxQy696yw@mail.gmail.com>
 <OS9PR01MB12149EA0C749BC29C7C949E32F544A@OS9PR01MB12149.jpnprd01.prod.outlook.com>
 <CAD21AoBbZEshyaK0PeiF_J4_S75EfF=Gcs=C+X-osoVoUnawuQ@mail.gmail.com>
 <CAHut+PssG+sHeV+Xo0g=S7xBb9FgDPjHYDR4iSuOdYXDq-Psng@mail.gmail.com>
In-Reply-To: 
 <CAHut+PssG+sHeV+Xo0g=S7xBb9FgDPjHYDR4iSuOdYXDq-Psng@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Fri, 13 Mar 2026 15:21:34 +0530
Message-ID: 
 <CAA4eK1LaSfAG7UAuy1xpnkWKM_YtrPuhbgAxYBFY3Sp_v_KqoQ@mail.gmail.com>
Subject: Re: Skipping schema changes in publication
To: Peter Smith <smithpb2250@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>,
	"Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
 shveta malik <shveta.malik@gmail.com>,
	vignesh C <vignesh21@gmail.com>, Shlok Kyal <shlok.kyal.oss@gmail.com>,
	Nisha Moond <nisha.moond412@gmail.com>,
 Ashutosh Sharma <ashu.coek88@gmail.com>,
	"David G. Johnston" <david.g.johnston@gmail.com>,
 Dilip Kumar <dilipbalaut@gmail.com>,
	"Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>, YeXiu <1518981153@qq.com>,
	Ian Lawrence Barwick <barwick@gmail.com>,
	Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1LaSfAG7UAuy1xpnkWKM_YtrPuhbgAxYBFY3Sp_v_KqoQ%40mail.gmail.com>
Precedence: bulk

On Fri, Mar 13, 2026 at 8:55=E2=80=AFAM Peter Smith <smithpb2250@gmail.com>=
 wrote:
>
> Hou-San (off-list) gave an interesting example of how it might look
> when the example is combined with the hypothetical future ability to
> exclude all schema tables from a "FOR ALL TABLES"
> CREATE PUBLICATION pub FOR ALL TABLES EXCEPT (TABLE t1, t2, TABLES IN
> SCHEMA s1);
>

So, if we follow this, in future, the syntax would look like:
Create publication pub1 FOR ALL TABLES EXCEPT (TABLE t1, t2, TABLES IN
SCHEMA s1, s2), ALL SEQUENCES EXCEPT (SEQUENCE s1);

I think if we use the above syntax then one can also argue that why
not use FOR ALL (TABLES, SEQUENCES) instead of ALL TABLES, ALL
SEQUENCES.

Instead the current command would like:
Create publication pub1 FOR ALL TABLES EXCEPT TABLE (t1, t2), EXCEPT
TABLES IN SCHEMA (s1, s2), ALL SEQUENCES EXCEPT SEQUENCE (seq1, seq2);

Though it is slightly lengthy it makes the syntax local such that the
meaning of a clause is determined by what is inside it, not by
something that appears ten words later.

--=20
With Regards,
Amit Kapila.