3 ms·
> - Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday) I'm curious what the use case of th
by petereisentraut 3y ago
> - Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday)
I'm curious what the use case of this is?
Deferrable constraints are usually considered for foreign keys, since there you might have to juggle updates to multiple tables and might violate the constraint in the intermediate states. But that doesn't appear to apply in that way to CHECK constraints.
- evangow 3y ago2 tables that reference each other and the foreign key columns both have a NOT NULL constraint.