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

Edit
ID 6099
Title Support EXCEPT tables and EXCEPT (column-list) in publications
CI (CFBot) Summary
Stats (from CFBot) Patch version: v29, Patch count: 4, First patch: +349−67, All patches: +2140−375
Topic Replication & Recovery
Tags Logical Replication
Created 2025-10-03 06:16:22
Last modified 2025-10-03 06:18:35 (2 months ago)
Latest email 2025-12-08 11:57:27 (7 hours ago)
Status
PG19-Drafts (2025-06-22 – 2026-02-28): Needs review
Target version 19
Authors Shlok Kyal (shlokkyal)
Reviewers Peter Smith (smithpb2250)Become reviewer
Committer
Links
Emails
Skipping schema changes in publication
First at 2022-03-22 07:08:43 by vignesh C <vignesh21 at gmail.com>
Latest at 2025-12-08 12:14:19 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v29-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-12-04 11:50:54 from Shlok Kyal <shlok.kyal.oss at gmail.com>
    Attachment (v29-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-12-04 11:50:54 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v28-0002-Support-ADD-ALL-TABLES-in-ALTER-PUBLICATION.patch) at 2025-11-19 10:04:04 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-11-13 06:08:17 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-11-11 10:20:36 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-11-06 11:16:48 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v24-0003-Skip-publishing-the-columns-specified-in-FOR-TAB.patch) at 2025-09-26 19:50:31 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-09-05 06:27:23 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-08-25 08:08:24 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v21-0003-Skip-publishing-the-columns-specified-in-FOR-TAB.patch) at 2025-08-20 09:00:36 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (PS_addFooterToPublicationOrTableDesc.diff) at 2025-08-15 00:53:10 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-08-13 09:21:42 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-08-06 13:10:55 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-08-03 16:07:00 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-07-21 19:33:37 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v16-0002-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-07-19 10:44:03 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-06-27 10:11:17 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-06-24 04:17:53 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-06-19 06:41:48 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-06-17 07:41:34 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2025-06-11 14:07:49 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Add-RESET-clause-to-Alter-Publication-which-will.patch) at 2023-01-20 10:00:54 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-11-16 10:05:31 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-11-07 13:39:41 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-08-18 17:41:30 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-08-08 09:23:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-08-08 07:16:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Skip-publishing-the-tables-specified-in-EXCEPT-TA.patch) at 2022-06-03 10:06:51 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Skip-publishing-the-tables-specified-in-EXCEPT-TA.patch) at 2022-05-23 05:13:03 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-05-21 05:30:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-05-18 17:45:08 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-RESET-clause-to-Alter-Publication-which-will-.patch) at 2022-05-14 13:32:54 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-RESET-option-to-Alter-Publication-which-will-.patch) at 2022-05-12 04:24:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Skip-publishing-the-tables-specified-in-EXCEPT-TA.patch) at 2022-04-29 11:42:59 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Skip-publishing-the-tables-specified-in-EXCEPT-TA.patch) at 2022-04-27 12:50:11 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Skip-publishing-the-tables-specified-in-EXCEPT-TA.patch) at 2022-04-21 03:15:07 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Skip-publishing-the-tables-of-schema.patch) at 2022-04-12 06:23:29 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Skip-publishing-the-tables-of-schema.patch) at 2022-03-26 14:07:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Skip-publishing-the-tables-of-schema.patch) at 2022-03-22 07:08:43 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
History
When Who What
2025-12-04 12:03:32 CFbot Patch does not need rebase anymore
2025-11-29 10:05:26 CFbot Patch needs rebase
2025-11-11 10:32:34 CFbot Patch does not need rebase anymore
2025-11-10 00:31:27 CFbot Patch needs rebase
2025-11-06 11:38:30 CFbot Patch does not need rebase anymore
2025-10-10 08:38:25 CFbot Patch needs rebase
2025-10-03 06:23:13 Peter Smith (smithpb2250) Added smithpb2250 as reviewer
2025-10-03 06:19:31 Shlok Kyal (shlokkyal) Removed shlokkyal from reviewers
2025-10-03 06:19:28 Shlok Kyal (shlokkyal) Added shlokkyal as reviewer
2025-10-03 06:18:35 Shlok Kyal (shlokkyal) Attached mail thread CALDaNm3=JrucjhiiwsYQw5-PGtBHFONa6F7hhWCXMsGvh=tamA@mail.gmail.com
2025-10-03 06:18:12 Shlok Kyal (shlokkyal) Detached mail thread CALDaNm3=JrucjhiiwsYQw5-PGtBHFONa6F7hhWCXMsGvh=tamA@mail.gmail.com
2025-10-03 06:16:22 Shlok Kyal (shlokkyal) Attached mail thread CALDaNm3=JrucjhiiwsYQw5-PGtBHFONa6F7hhWCXMsGvh=tamA@mail.gmail.com
2025-10-03 06:16:22 Shlok Kyal (shlokkyal) Created patch record
Edit