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/
