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/
