| From: | Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Subject: | Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions |
| Date: | 2026-01-26 08:56:36 |
| Message-ID: | E2469CD8-8B08-4EA2-B540-28ACE1A9B5C9@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Jan 26, 2026, at 10:51, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
>
>
> While working on v3, I also noticed another issue that may be a bug. When creating an index on a partitioned table, the index is automatically created on all partitions. However, if a column type change causes an index rebuild, it appears that the rebuilt index may be missing from child partitions. I will verify this behavior and, if confirmed, discuss it in a separate thread.
>
I have verified the problem. The real problem is, after index rebuild, indisreplident flag of index on child partition will be 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2026-01-26 09:01:14 | Re: Batching in executor |
| Previous Message | Zsolt Parragi | 2026-01-26 08:53:00 | Re: unclear OAuth error message |