Re: Is it possible to set a NOT NULL constraint deferrable? - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Is it possible to set a NOT NULL constraint deferrable?
Date
Msg-id 200312062354.hB6NsRi08699@candle.pha.pa.us
Whole thread Raw
In response to Is it possible to set a NOT NULL constraint deferrable?  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
List pgsql-sql
Olivier Hubaut wrote:
> I can put all the other constaints deferrable, but the *NOT NULL* one 
> seems to be undeferrable.
> 
> Is ther a way to by-pass this or is do you know if this is planned in 
> the future versions?

Only foreign key constraints are deferrable.  Many want UNIQUE to be
deferrable, but you are the first to ask for NOT NULL.

Not sure when this will be done.  Sorry.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-sql by date:

Previous
From: Robert Treat
Date:
Subject: Re: Help converting Oracle instead of triggers to PostgreSQL
Next
From: Greg Stark
Date:
Subject: Re: Index not recognized