Thread: Deferrable NOT NULL constraints in 9.3?

<div>Hi hackers.</div><div> </div><div>Are there any plans to include DEFERRABLE NOT NULL constraints in 9.3 so one can
dothis?</div><div><pre class="lang-sql prettyprint prettyprinted" style=""> 
create table test(a varchar not null deferrable initially deferred);</pre></div><div>This works in Oracle and is quite
handywhen working with ORMs.</div><div> </div><div>Thanks.</div><div> </div><div class="origo-email-signature">--<br />
AndreasJoseph Krogh <andreak@officenet.no>      mob: +47 909 56 963<br /> Senior Software Developer / CTO -
OfficeNetAS - http://www.officenet.no<br /> Public key: http://home.officenet.no/~andreak/public_key.asc</div> 

On Thu, Nov 8, 2012 at 4:45 AM,  <andreak@officenet.no> wrote:
> Are there any plans to include DEFERRABLE NOT NULL constraints in 9.3 so one
> can do this?
>
> create table test(a varchar not null deferrable initially deferred);
>
> This works in Oracle and is quite handy when working with ORMs.

Not to my knowledge ... although I can't claim to know everything that
anyone is working on.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Nov 8, 2012 at 4:45 AM,  <andreak@officenet.no> wrote:
>> Are there any plans to include DEFERRABLE NOT NULL constraints in 9.3 so one
>> can do this?
>> 
>> create table test(a varchar not null deferrable initially deferred);
>> 
>> This works in Oracle and is quite handy when working with ORMs.

> Not to my knowledge ... although I can't claim to know everything that
> anyone is working on.

You could get the effect by applying the not-null check in a custom
constraint trigger.  A bit tedious but it'd work.
        regards, tom lane