I'd like to create a new table with a NOT NULL constraint that is deferred
until the transaction commit. Unfortunately with this definition:
CREATE TABLE foo (bar INTEGER NOT NULL INITIALLY DEFERRED);
I get this error:
ERROR: Misplaced INITIALLY DEFERRED clause
Is it possible to do this or do I have to define it as a CHECK constraint
and defer that?
Greg