Re: DEFERRABLE NOT NULL constraint

[Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>]

På tirsdag 05. februar 2013 kl. 11:04:27, skrev Thomas Kellerer <spam_eater@xxxxxxx>:

Andreas Joseph Krogh, 05.02.2013 10:57:
> The value of having NOT NULL deferrable is, well, to not check for
> NULL until the tx commits. When working with ORMs this often is the
> case, especially with circular FKs.

With circular FKs it's enough to define the FK constraint as deferred.

 

I meant; circular FKs which are also NOT NULL

 

--
Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>      mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc