Re: Unexpected reindex when altering column types for partitioned tables - Mailing list pgsql-hackers

Added to CF, thanks Álvaro!

On Fri, Jun 12, 2026 at 3:03 PM Álvaro Herrera <alvherre@kurilemu.de> wrote:
>
> Hi,
>
> On 2026-Jun-08, Álvaro Rodríguez wrote:
>
> > When running the ALTER TABLE ALTER COLUMN TYPE operation, certain type
> > changes are supposed to not require a reindex. For example, text to
> > varchar or varchar(n) to varchar(m) when m > n. However, this turns
> > out to not be the case for indexes (including pk / unique constraints)
> > on partitioned tables. Patch 0001 (attached) demonstrates this
> > behavior with a new regression test. In this case, the table rewrite
> > is avoided but the indexes are rebuilt.
>
> I agree with the problem statement, and I think the proposed solution
> has the right shape.  This obviously has to be kept for pg20, so let's
> discuss further during the next commitfest; please create a CF entry for
> it.
>
> Thanks,
>
> --
> Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/