Re: Partitioned index marked valid while a partition is pending detach

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: surya poondla <suryapoondla4(at)gmail(dot)com>
Cc: michael(at)paquier(dot)xyz, alvherre(at)kurilemu(dot)de, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Partitioned index marked valid while a partition is pending detach
Date: 2026-11-12 04:30:38
Message-ID: CAGRkXqTMjntGLOwnJpfne5xNEFeKSjW_NTGQXW=wC-hMRVUV2A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Surya,

Thanks for reviewing v4. Just realize I accidentally sent the v4 twice....

v5 address your 003 comments.

> 1)...
Added new ALTER COLUMN TYPE test

> 2)....
I added one sentence in alter_talbe.sgml to talk about that case.

Thanks,
Shihao

Attachment Content-Type Size
v5-0001-Count-partitions-pending-detach-when-validating-a-pa.patch application/octet-stream 1.2 KB
v5-0002-Test-partitioned-index-validity-while-a-partition-is.patch application/octet-stream 4.3 KB
v5-0003-Let-DDL-see-partitions-pending-detach.patch application/octet-stream 22.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-11-12 04:36:50 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned
Previous Message João Rito 2026-11-12 04:20:35 Re: [PATCH] Periodically refresh database frozen IDs during autovacuum