Skip site navigation (1) Skip section navigation (2)

Deferrable NOT NULL constraints in 9.3?

From: andreak(at)officenet(dot)no
To: pgsql-hackers(at)postgresql(dot)org
Subject: Deferrable NOT NULL constraints in 9.3?
Date: 2012-11-08 09:45:28
Message-ID: OrigoEmail.58.e6f699b252b2deb.13adf64b398@prod2.officenet.no (view raw or flat)
Thread:
Lists: pgsql-hackers
<div>Hi hackers.</div>

<div> </div>

<div>Are there any plans to include DEFERRABLE NOT NULL constraints in 9.3 so one can do this?</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 handy when working with ORMs.</div>

<div> </div>

<div>Thanks.</div>

<div> </div>

<div class="origo-email-signature">--<br>
Andreas Joseph Krogh &lt;andreak(at)officenet(dot)no&gt;      mob: +47 909 56 963<br>
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no<br>
Public key: http://home.officenet.no/~andreak/public_key.asc</div>

Attachment: unknown_filename
Description: text/html (682 bytes)

Responses

pgsql-hackers by date

Next:From: Amit KapilaDate: 2012-11-08 14:26:27
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Previous:From: DenisDate: 2012-11-08 09:04:34
Subject: Re: [HACKERS] pg_dump and thousands of schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group