Re: DEFERRABLE NOT NULL constraint - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: DEFERRABLE NOT NULL constraint
Date
Msg-id OrigoEmail.170.29cc887f9e71edb5.13ca9d9ffaa@prod2.officenet.no
Whole thread Raw
In response to Re: DEFERRABLE NOT NULL constraint  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: DEFERRABLE NOT NULL constraint  (Alban Hertroys <haramrae@gmail.com>)
Re: DEFERRABLE NOT NULL constraint  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
P=C3=A5 tirsdag 05. februar 2013 kl. 11:04:27, skrev Thomas Kellerer &=
lt;spam_eater@gmx.n=
et>:

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
And=
reas 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.


=C2=A0

I meant; circular FKs which are also NOT NULL

=C2=A0

--
Andreas Joseph Krogh <andreak@officenet.no>=C2=A0 =C2=A0 =C2=A0 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

=C2=A0=

pgsql-general by date:

Previous
From: Виктор Егоров
Date:
Subject: Re: DEFERRABLE NOT NULL constraint
Next
From: Thierry Hauchard
Date:
Subject: COPY FROM on Windows and accentuated characters in the file path