citus icon indicating copy to clipboard operation
citus copied to clipboard

CREATE INDEX CONCURRENTLY IF NOT EXISTS invalidates index

Open devony opened this issue 1 month ago • 0 comments

Citus 13.0.1, Postgres 17.2

Issuing CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_name ... on a table where the index exists returns

relation "ix_name" already exists, skipping

but actually ends up invalidating the index. This happens on both local and distributed tables.

Expected behavior: Index stays valid

devony avatar Nov 14 '25 07:11 devony