Support EXCEPT tables in publications

Edit
ID 6099
Title Support EXCEPT tables in publications
CI (CFBot) Needs rebase! Needs rebase since 11 hours. Failing since 11 hours.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Logical Replication
Created 2025-10-03 06:16:22
Last modified 2026-03-01 00:00:03 (3 weeks ago)
Latest email 2026-03-20 11:56:02 (yesterday)
Status
PG20-Drafts (2026-03-01 – 2027-02-28): Needs review
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
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-03-20 11:56:02 by Amit Kapila <amit.kapila16 at gmail.com>
Latest 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>
    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-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