| rule name | description |
|---|
| adding-field-with-default | Prevent blocking reads/writes to table while table is rewritten on PG < 11. |
| adding-foreign-key-constraint | Prevent blocking writes to tables while verifying foreign key constraint. |
| adding-not-nullable-field | Prevent blocking reads/writes to table while table is scanned on PG < 11. |
| adding-serial-primary-key-field | Prevent blocking reads/writes to table while index is built. |
| changing-column-type | Prevent breaking existing clients that depend on column type. Prevent blocking reads/writes to table while table is rewritten. |
| constraint-missing-not-valid | Prevent blocking writes to the table while the scan occurs. |
| disallowed-unique-constraint | Prevent blocking reads/writes to table while index is built. |
| prefer-robust-stmts | Ensure migrations are atomic or retriable. |
| prefer-text-field | Prevent blocking reads and writes to table while table metadata is updated. |
| require-concurrent-index-creation | Prevent blocking writes to table while index is created. |
| require-concurrent-index-deletion | Prevent blocking reads/writes to table while index is dropped. |
| transaction-nesting | Ensure migrations use transactions correctly. |
| ban-create-domain-with-constraint | Domains with constraints have poor support for online migrations |
| ban-alter-domain-with-add-constraint | Domains with constraints have poor support for online migrations |
| require-timeout-settings | Require lock and statement timeouts |