Re: Invalid index on partitioned table - is this a bug or feature? - Mailing list pgsql-hackers

On 2025-Jan-22, Dmitry Koval wrote:

> Hi!
> If you create an index on a partitioned table using a method that uses
> pg_dump:
> 
> (a) "ALTER TABLE ONLY ... ADD CONSTRAINT .. PRIMARY KEY ..."
> or
> (b) "CREATE INDEX ... ON ONLY ..."
> 
> then the index for the partitioned table is created with the INVALID
> flag.

Yes.  You need to attach child indexes on all partitions so that this
index becomes valid.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/