Horton

Re: DEFERRABLE NOT NULL constraint

Thomas Kellerer <spam_eater@gmx.net>

View thread View on postgr.es
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-general@postgresql.org
Date: 2013-02-05T10:04:27Z
Lists: pgsql-general 
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.