Support EXCEPT tables in publications

Edit
ID 6099
Title Support EXCEPT tables in publications
CI (CFBot) Summary
Stats (from CFBot) Patch count: 2, First patch: +16−16, All patches: +19−19
Tags Logical Replication
Created 2025-10-03 06:16:22
Last modified 2026-04-02 04:22:16 (1 week ago)
Latest email 2026-04-01 03:55:53 (1 week ago)
Status
PG19-Final (2026-03-01 – 2026-04-09): Committed
PG20-Drafts (2026-03-01 – 2027-02-28): Moved to different CF
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
Target version 19
Authors Shlok Kyal (shlokkyal)
Reviewers Peter Smith (smithpb2250)Become reviewer
Committer Amit Kapila (amitkapila)
Links
Emails
Skipping schema changes in publication
First at 2022-03-22 07:08:43 by vignesh C <vignesh21 at gmail.com>
Latest at 2026-04-01 03:55:53 by Peter Smith <smithpb2250 at gmail.com>
Latest attachment (0002-Reuse-table_object-in-publication-command-syntax.patch) at 2026-03-31 09:30:30 from vignesh C <vignesh21 at gmail.com>
    Attachment (0002-Reuse-table_object-in-publication-command-syntax.patch) at 2026-03-31 09:30:30 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Change-syntax-of-EXCEPT-TABLE-clause-in-publicati.patch) at 2026-03-30 14:44:30 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-simplify-gram.y-atop-of-your-patch_patch) at 2026-03-30 05:51:23 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-Change-syntax-of-EXCEPT-TABLE-clause-in-publicati.patch) at 2026-03-27 20:49:34 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Change-syntax-of-EXCEPT-TABLE-clause-in-publicati.patch) at 2026-03-27 07:50:14 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Change-syntax-of-EXCEPT-TABLE-clause-in-publication-.patch) at 2026-03-26 15:24:37 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v67-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-20 02:21:34 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v66-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-18 13:21:02 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v65-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-17 15:51:15 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v64-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-17 06:53:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-few-issues-in-commit-fd366065e0.patch) at 2026-03-16 10:56:00 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (PS_use_GetPublicationsStr.txt) at 2026-03-16 06:35:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v63-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-15 12:25:34 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v62-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-11 10:07:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v61-0001-Add-support-for-EXCEPT-TABLE-in-ALTER-PUBLICATIO.patch) at 2026-03-10 12:49:34 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v60-0001-Support-SET-ALL-TABLES-EXCEPT-TABLE-in-ALTER-PUB.patch) at 2026-03-09 10:53:37 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-doc-change.patch.txt) at 2026-03-09 04:36:00 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v59-0001-Support-SET-ALL-TABLES-EXCEPT-TABLE-in-ALTER-PUB.patch) at 2026-03-09 02:52:31 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v58-0002-Support-DROP-EXCEPT-TABLE-in-ALTER-PUBLICATION.patch) at 2026-03-06 08:17:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v57-0001-Support-SET-EXCEPT-TABLE-in-ALTER-PUBLICATION.patch) at 2026-03-05 09:35:42 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v56-0001-Allow-table-exclusions-in-publications-via-EXCEP.patch) at 2026-03-04 08:24:29 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v55-0001-Allow-table-exclusions-in-publications-via-EXCEP.patch) at 2026-03-03 15:46:44 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v54-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-03-02 13:21:21 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v53-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-03-01 03:11:30 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v52-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-28 08:13:15 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v51-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-27 06:39:59 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v50-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-25 17:13:10 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v49-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-25 07:04:41 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-23 06:07:35 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v47-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-20 08:38:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v46_amit_1.patch.txt) at 2026-02-19 10:36:46 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v46-0002-Extended-tests-for-EXCEPT-TABLE-patch.patch) at 2026-02-19 04:43:30 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v45-0002-Extended-tests-for-EXCEPT-TABLE-patch.patch) at 2026-02-17 05:43:32 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (nisha_v44_suggestion.txt) at 2026-02-16 12:41:16 from Nisha Moond <nisha.moond412 at gmail.com> (Patch: Yes)
    Attachment (v44-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-16 03:20:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v43-0002-Extended-tests-for-EXCEPT-TABLE-patch.patch) at 2026-02-12 06:58:28 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-10 17:41:03 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (DifferentPubViaRoot.txt) at 2026-02-06 10:23:57 from shveta malik <shveta.malik at gmail.com> (Patch: No)
    Attachment (v41-0002-Extended-tests-for-EXCEPT-TABLE-patch.patch) at 2026-02-05 05:29:06 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v40-0002-handle-EXCEPT-TABLE-correctly-with-partitioned-t.patch) at 2026-02-04 08:16:06 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v39-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-02-03 16:52:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v38-0002-Restrict-EXCEPT-TABLE-to-root-partitioned-tables-apporach-3.patch) at 2026-01-29 15:11:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (Approach1_v37_fail.txt) at 2026-01-28 05:16:07 from shveta malik <shveta.malik at gmail.com> (Patch: No)
    Attachment (v37-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-01-27 14:37:01 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-01-22 12:04:25 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (Approach1_challenges.txt) at 2026-01-19 09:38:17 from shveta malik <shveta.malik at gmail.com> (Patch: No)
    Attachment (v35-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2026-01-06 12:43:17 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-12-23 06:32:49 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-12-18 11:45:06 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-12-16 09:20:41 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-12-10 10:21:53 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Skip-publishing-the-tables-specified-in-EXCEPT-T.patch) at 2025-12-09 17:46:59 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    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
2026-04-02 04:22:16 Hayato Kuroda (ha-kun) Closed in commitfest PG19-Final with status: Committed
2026-04-02 04:22:16 Hayato Kuroda (ha-kun) Changed committer to amitkapila
2026-04-02 04:22:16 Hayato Kuroda (ha-kun) Moved from CF PG20-Drafts to CF PG19-Final
2026-03-26 15:46:39 CFbot Patch does not need rebase anymore
2026-03-21 20:47:27 CFbot Patch needs rebase
2026-03-01 00:00:03 CFbot Moved from CF PG19-Drafts to CF PG20-Drafts
2026-02-03 17:14:39 CFbot Patch does not need rebase anymore
2026-01-29 21:24:49 Peter Smith (smithpb2250) Changed name to Support EXCEPT tables in publications
2026-01-29 15:33:41 CFbot Patch needs rebase
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