Re: Is it possible to set a NOT NULL constraint deferrable?

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