Horton

Re: DEFERRABLE NOT NULL constraint

Andreas Joseph Krogh <andreak@officenet.no>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreak@officenet.no>
To: pgsql-general@postgresql.org
Date: 2013-02-05T10:15:55Z
Lists: pgsql-general

Attachments

<div>På tirsdag 05. februar 2013 kl. 11:04:27, skrev Thomas Kellerer &lt;<a href="mailto:spam_eater@gmx.net" target="_blank">spam_eater@gmx.net</a>&gt;:</div>

<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="display:inline; font-family: monospace; font-size: 12px;">Andreas Joseph Krogh, 05.02.2013 10:57:<br>
&gt; The value of having NOT NULL deferrable is, well, to not check for<br>
&gt; NULL until the tx commits. When working with ORMs this often is the<br>
&gt; case, especially with circular FKs.<br>
<br>
With circular FKs it's enough to define the FK constraint as deferred.</div>
</blockquote>

<div> </div>

<div>I meant; circular FKs which are also NOT NULL</div>

<div> </div>

<div class="origo-email-signature">--<br>
Andreas Joseph Krogh &lt;andreak@officenet.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>

<div> </div>