#1832·kysely

Support `not valid` check constraint clause.

Author: igalklebanovCreated May 13, 2026Updated Aug 25, 2026
Labelsenhancementpostgresapi

Hey

The not valid constraint clause allows to create check constraints that enforce correctness of future data only (inserts or updates), allowing to safely backfill a column and then validate the constraint (doesn't block reads/writes) AND set not null with way less locking given the constraint is now valid.