discourse/db
Alan Guo Xiang Tan 5ddae1c574
DEV: Rerun AddIndexToPostStatComposerColumns migration (#31765)
The previous version of the migration is not idempotent and can result
in indexes created but marked as "invalid" by Postgres.

Per postgres documentation:

If a problem arises while scanning the table, such as a deadlock or a
uniqueness violation in a unique index,
the CREATE INDEX command will fail but leave behind an "invalid" index.
This index will be ignored for querying
purposes because it might be incomplete; however it will still consume
update overhead. The recommended recovery
  method in such cases is to drop the index and try again to perform
  CREATE INDEX CONCURRENTLY.
2025-03-12 11:49:51 +08:00
..
fixtures DEV: raise error on deprecated icon name caught on JS in system and qunit tests (#30942) 2025-01-24 09:26:00 +08:00
migrate DEV: Rerun AddIndexToPostStatComposerColumns migration (#31765) 2025-03-12 11:49:51 +08:00
post_migrate DEV: Backfill API key scope modes (#31606) 2025-03-11 10:00:27 +08:00
api_test_seeds.rb DEV: Apply syntax_tree formatting to db/* 2023-01-09 11:59:41 +00:00