Horton
Menu

Re: Skipping schema changes in publication

vignesh C <vignesh21@gmail.com>

View thread
From: vignesh C <vignesh21@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Shlok Kyal <shlok.kyal.oss@gmail.com>, shveta malik <shveta.malik@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-02-28T08:13:15Z
Lists: pgsql-hackers

Attachments

On Thu, 26 Feb 2026 at 19:41, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Feb 25, 2026 at 10:43 PM Shlok Kyal <shlok.kyal.oss@gmail.com> wrote:
> >
> > I have also split the patch 0002 to 0002 and 0003
> > 0001 - Support CREATE PUBLICATION ... EXCEPT TABLE syntax
> >
>
> Few comments:
> =============
> *
>   * pub_all_obj_type is one of:
>   *
> - * TABLES
> + * TABLES [EXCEPT [TABLE] ( table [, ...] )]
> As per above syntax in gram.y, [TABLE] is optional but won't it be
> confusing when we also support sequences? Then we need to identify
> whether the object given in EXCEPT list is table or sequence. So, I
> think it is better to keep TABLE as non-optional.
>
> * Can we have one test related to INHERITS for actual replication
> unless it is already there?

Thanks for the comments, these comments are addressed in the v52
version patch attached.
Also the comments from [1] are addressed in the same.
[1] - https://www.postgresql.org/message-id/CAA4eK1JrqoPvrFxZEO2rB%3D-jXK1BQdJZz2_2oeZqCQR3GRWC2g%40mail.gmail.com

Regards,
Vignesh

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.