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

From: Sami Imseih <samimseih(dot)pg(at)gmail(dot)com>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Alberto Piai <alberto(dot)piai(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Xuneng Zhou <xunengzhou(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Subject: Re: tablecmds: fix bug where index rebuild loses replica identity on partitions
Date: 2026-09-04 14:45:05
Message-ID: CAN12+YKf952x9F0OzGBSk_OGswjZC1-c2MYv0gLX=4P_br6P+Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> PFA v17: addressed Sami’s comments in 0002, and 0001 is unchanged from v16.

Thanks!

After looking at v17, I thought 0002 should stay focused on preserving
descendant partition index properties, so I split the non-descendant
DEPENDS ON EXTENSION preservation into its own patch, v18-0001.

v18-0002 is based on v17-0001, with SET EXPRESSION coverage added.

v18-0003 is based on v17-0002. The only changes here are the pieces from 0001,
the rest of the partition-descendant preservation remains the same.

--
Sami Imseih
Amazon Web Services (AWS)

Attachment Content-Type Size
v18-0002-Preserve-index-per-column-statistics-targets-acr.patch application/octet-stream 12.8 KB
v18-0001-Preserve-index-DEPENDS-ON-EXTENSION-links-across.patch application/octet-stream 7.1 KB
v18-0003-Preserve-descendant-partition-index-properties-a.patch application/octet-stream 38.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2026-09-04 15:08:39 Re: Make the transition state of avg(int2)/avg(int4)/sum(int2)/sum(int4) internal
Previous Message Dmitry Dolgov 2026-09-04 14:35:16 Re: Add ssl_(supported|shared)_groups to sslinfo