Deferred NOT NULL? - Mailing list pgsql-general

From Gregory Wood
Subject Deferred NOT NULL?
Date
Msg-id 00fa01c09c1a$9fd20d80$7889ffcc@comstock.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple triggers/rules
Next
From: Antonis Antoniou
Date:
Subject: AllocSetAlloc()