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/