Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions - Mailing list pgsql-hackers

From Chao Li
Subject Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions
Date
Msg-id E2469CD8-8B08-4EA2-B540-28ACE1A9B5C9@gmail.com
Whole thread Raw
In response to Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions
List pgsql-hackers

> On Jan 26, 2026, at 10:51, Chao Li <li.evan.chao@gmail.com> wrote:
>
>
> While working on v3, I also noticed another issue that may be a bug. When creating an index on a partitioned table,
theindex is automatically created on all partitions. However, if a column type change causes an index rebuild, it
appearsthat the rebuilt index may be missing from child partitions. I will verify this behavior and, if confirmed,
discussit in a separate thread. 
>

I have verified the problem. The real problem is, after index rebuild, indisreplident flag of index on child partition
willbe lost, which should be a bug. I will start a new thread to give more details of the problem and propose a fix. 

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/







pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: unclear OAuth error message
Next
From: Amit Langote
Date:
Subject: Re: Batching in executor