Hi hackers, Commit fc55c7ff8d1 [1] (back-patched through v11 as e90e9275f56) added logic to skip invalid indexes when ALTER TABLE ... ATTACH PARTITION matches partition indexes to the parent table's indexes. This prevents choosing an incomplete partitioned index as a match, which could create inconsistent partition index trees.
However, this behavior was never documented. A user who has an invalid index on a partition (e.g., from a failed CREATE INDEX CONCURRENTLY) may be surprised when ATTACH PARTITION silently creates a new index instead of attaching the existing one. The attached patch adds a sentence to the ALTER TABLE reference page noting that invalid indexes are skipped during this matching and that a new index is created when no valid equivalent is found. This is a doc-only change with no code modifications. I believe it could be back-patched to all supported branches since the behavior already exists there. [1] https://github.com/postgres/postgres/commit/e90e9275f56 -- Mohamed Ali AWS RDS
v1-0001-doc-attach-partition-invalid-index-skip.patch
Description: Binary data
