Commit Graph

2 Commits (pd/write-buffer-wal)

Author SHA1 Message Date
Marco Neumann f1fbcca23c
fix: make concurrent index creations idempotent (#8450)
* fix: make concurrent index creations idempotent

`CREATE INDEX CONCURRENTLY` may fail and leave an invalid index behind.
See:
<https://www.postgresql.org/docs/current/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY>

Invalid indexes will NOT be used for queries, however they is also useless and
technically the migration wasn't successful. Since #8407 we detect this
situation. #8394 allows us to fix these migrations. #8434 makes sure
that we don't mess this up (esp. that the "other checksum" pragmas are
correct).

For #7897.

* fix: multi-line processing in `check_linear_migrations.sh`

---------

Co-authored-by: kodiakhq[bot] <49736102+kodiakhq[bot]@users.noreply.github.com>
2023-08-09 19:16:35 +00:00
Marco Neumann 2156bc7e05
feat: static migrations checks (#8434)
Co-authored-by: kodiakhq[bot] <49736102+kodiakhq[bot]@users.noreply.github.com>
2023-08-07 15:13:28 +00:00