Re: Unexpected reindex when altering column types for partitioned tables

From: Álvaro Rodríguez <alvaro(at)datadoghq(dot)com>
To: Alberto Piai <alberto(dot)piai(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: Unexpected reindex when altering column types for partitioned tables
Date: 2026-09-18 19:59:15
Message-ID: CA+C_kKWdUWOOZjmq+zSO+8qcTGcLK12394=jcw5J76fC9w185Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Yup! I was aware of that but forgot to update the thread, please find
the rebased versions attached.

Whoops, that was only a partial rebase. v4 attached!
Álvaro

Attachment Content-Type Size
v4-0001-Add-regression-test-to-highlight-unexpected-behav.patch application/octet-stream 4.2 KB
v4-0003-Skip-index-rewriting-for-PK-associated-indexes-wh.patch application/octet-stream 5.9 KB
v4-0002-Skip-index-rewriting-when-possible-on-ALTER-TABLE.patch application/octet-stream 10.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2026-09-18 20:14:16 Re: Reject WAIT FOR earlier in transaction-snapshot mode
Previous Message Haibo Yan 2026-09-18 19:22:37 Re: remove_useless_joins vs. bug #19560