citus
citus copied to clipboard
CREATE INDEX CONCURRENTLY IF NOT EXISTS invalidates index
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