CREATE INDEX CONCURRENTLY IF NOT EXISTS invalidates index
Open
needs-investigation
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
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
Contributor guide
Assessment
This issue has not been assessed yet.