tablecmds: fix bug where index rebuild loses replica identity on partitions

6440

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v19, Patch count: 3, First patch: +59−0, All patches: +915−24

Tags

Bugfix DDL

Created

2026-01-28 06:39:00

Last modified

2026-11-10 16:31:10 (22 minutes ago)

Latest email

2026-10-06 11:37:09 (1 month ago)

Status

PG20-4 (2027-01-01 – 2027-01-31): Needs review

PG20-3 (2026-11-01 – 2026-11-30): Moved to different CF

PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF

Target version

stable

Authors

Chao Li (chaol)

Reviewers

Sami Imseih (simseih) Log in to become reviewer

Committer

Links

Emails

tablecmds: fix bug where index rebuild loses replica identity on partitions: First at 2026-01-27 05:13:32 by Chao Li <li.evan.chao at gmail.com>
Latest at 2026-10-06 11:37:09 by Álvaro Rodríguez <alvaro at datadoghq.com>
Latest attachment (v19-0001-Preserve-index-DEPENDS-ON-EXTENSION-across-ALTER.patch) at 2026-09-05 16:44:17 from Sami Imseih <samimseih.pg at gmail.com>
    Attachment (v19-0001-Preserve-index-DEPENDS-ON-EXTENSION-across-ALTER.patch) at 2026-09-05 16:44:17 from Sami Imseih <samimseih.pg at gmail.com> (Patch: No)
    Attachment (v18-0002-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-09-04 14:45:05 from Sami Imseih <samimseih.pg at gmail.com> (Patch: No)
    Attachment (v17-0001-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-08-28 02:51:52 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v16-0001-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-08-27 09:21:45 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v15-0001-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-08-27 05:38:07 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v15-0001-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-08-26 05:30:07 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v14-0001-Preserve-index-per-column-statistics-targets-acr.patch) at 2026-08-24 22:28:41 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v13-0001-tablecmds-preserve-partition-index-names-during-.patch) at 2026-08-03 05:16:58 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v12-0002-tablecmds-preserve-replica-identity-and-cluster-.patch) at 2026-07-29 17:07:08 from Sami Imseih <samimseih at gmail.com> (Patch: No)
    Attachment (v11-0001-tablecmds-preserve-partition-index-names-during-.patch) at 2026-07-29 03:28:10 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (partition_index_propert_loss.sql) at 2026-07-28 20:05:03 from Sami Imseih <samimseih at gmail.com> (Patch: No)
    Attachment (v10-0001-tablecmds-preserve-partition-index-names-during-.patch) at 2026-07-28 08:54:25 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v9-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-07-16 02:49:59 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v8-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-04-14 03:13:40 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v7-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-03-24 07:25:44 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v6-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-03-23 07:56:25 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v5-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-03-19 05:06:24 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v4-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-02-26 06:59:58 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v3-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-01-28 02:49:45 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v2-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-01-27 08:30:10 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v1-0001-tablecmds-fix-bug-where-index-rebuild-loses-repli.patch) at 2026-01-27 05:13:32 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)

History

When	Who	What
2026-11-10 16:31:10	Sami Imseih (simseih)	Moved from CF PG20-3 to CF PG20-4
2026-10-01 00:00:08	CFbot	Moved from CF PG20-2 to CF PG20-3
2026-08-27 09:43:38	CFbot	Patch does not need rebase anymore
2026-08-27 06:02:41	CFbot	Patch needs rebase
2026-08-24 22:37:36	CFbot	Patch does not need rebase anymore
2026-08-14 01:37:28	CFbot	Patch needs rebase
2026-08-12 18:58:49	Sami Imseih (simseih)	Added simseih as reviewer
2026-08-01 00:00:09	CFbot	Moved from CF PG20-1 to CF PG20-2
2026-07-16 03:04:31	CFbot	Patch does not need rebase anymore
2026-07-10 19:55:26	CFbot	Patch needs rebase
2026-05-12 02:21:35	Chao Li (chaol)	Changed tags to Bugfix, DDL
2026-04-14 03:00:14	Chao Li (chaol)	Changed tags to Bugfix, DDL, PGConf.dev
2026-04-10 00:00:02	CFbot	Moved from CF PG19-Final to CF PG20-1
2026-02-26 07:33:32	CFbot	Patch does not need rebase anymore
2026-02-26 06:35:26	CFbot	Patch needs rebase
2026-01-29 14:15:09	Álvaro Herrera (alvherre)	Changed tags to Bugfix, DDL
2026-01-28 06:39:00	Chao Li (chaol)	Attached mail thread DB533C25-C6BA-4C0F-8046-96168E9CDD72@gmail.com
2026-01-28 06:39:00	Chao Li (chaol)	Created patch record