Horton
Menu

Re: Skipping schema changes in publication

Masahiko Sawada <sawada.mshk@gmail.com>

View thread
From: Masahiko Sawada <sawada.mshk@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: 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>, Peter Smith <smithpb2250@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>
Date: 2026-03-10T20:54:31Z
Lists: pgsql-hackers 
On Wed, Mar 4, 2026 at 3:01 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Mar 4, 2026 at 2:49 PM shveta malik <shveta.malik@gmail.com> wrote:
> >
> > On Wed, Mar 4, 2026 at 1:54 PM vignesh C <vignesh21@gmail.com> wrote:
> > >
> > > Here is an updated version with a couple of typos fixed and separated
> > > the describe table query based on versions which make it more easier
> > > to read.
> > >
> >
> > v56 LGTM.
> >
>
> Pushed.

Sorry for joining the discussion late.

I've tried with the new EXCEPT clause and I have some questions about
the newly introduced syntax. With this feature, we can now write:

CREATE PUBLICATION pub FOR ALL TABLES EXCEPT TABLE (a, b, c);

The exclusion table list is written in the form of TABLE (a, b, c) but
it's quite different from the inclusion table list we can specify
(e.g., TABLE a, TABLE b, TABLE c). I'm concerned that it could confuse
users. Have these points already been discussed? Also, isn't the TABLE
after EXCEPT redundant?

Regards,

-- 
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix miscellaneous issues in EXCEPT publication clause.

  2. Change syntax of EXCEPT TABLE clause in publication commands.

  3. Add support for EXCEPT TABLE in ALTER PUBLICATION.

  4. Allow table exclusions in publications via EXCEPT TABLE.

  5. Add wait_for_subscription_sync for TAP tests.