Horton
Menu

Re: Skipping schema changes in publication

Peter Smith <smithpb2250@gmail.com>

View thread
From: Peter Smith <smithpb2250@gmail.com>
To: vignesh C <vignesh21@gmail.com>
Cc: shveta malik <shveta.malik@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, Shlok Kyal <shlok.kyal.oss@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-01-29T21:36:53Z
Lists: pgsql-hackers 
Hi Vignesh/Shlok.

1.
I've changed the name of the CF entry [1] for this because EXCEPT
(column-list) is no longer part of the current focus.

BEFORE
Support EXCEPT tables and EXCEPT (column-list) in publications
AFTER
Support EXCEPT tables in publications

2.
I understand the latest patch structure to be like:

0001 + 0002 (approach #1)
or
0001 + 0002 (approach #3)

AFAICT, this is breaking the CF bot, which attempts to apply all
patches at once [2]. IMO, next time you should change the patch suffix
of "0002 (approach #3)" to something like ".txt" or ".nocfbot", so
CFbot won't see it, and we can continue to get CI results for the
other patches.

======
[1] https://commitfest.postgresql.org/patch/6099/
[2] https://cfbot.cputube.org/patch_6099.log

Kind Regards,
Peter Smith.
Fujitsu Australia

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.