| 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-11 01:22:10 |
| Message-ID: | CAGRkXqQdrzzhX_A4TW_DaR4UteJbmzDRe6ECs1Oo2_vNvcr8CQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Surya,
Thanks for testing each patch on its own.
0001 alone leaves the index invalid, which is safe. A plain DETACH on
master does the same, so I would handle that separately.
v4-0003 now lets ALTER TABLE on the parent reach p1, and
pg_publication_tables leaves p1 out again. This also fixes the DROP
COLUMN case. I would rather not refuse DDL on the stable branches.
But I am happy to go with what Michael and Alvaro prefer.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Count-partitions-pending-detach-when-validating-a-pa.patch | application/octet-stream | 1.2 KB |
| v4-0002-Test-partitioned-index-validity-while-a-partition-is.patch | application/octet-stream | 4.3 KB |
| v4-0003-Let-DDL-see-partitions-pending-detach.patch | application/octet-stream | 21.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chao Li | 2026-11-11 01:23:27 | Re: extension_control_path: ignore empty elements and deduplicate directories |
| Previous Message | shihao zhong | 2026-11-11 01:20:32 | Re: Partitioned index marked valid while a partition is pending detach |