Andreas Joseph Krogh, 05.02.2013 11:15:
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
A deferrable FK is still enough for that scenario as you can insert FK values that do not yet exist. See Alban's answer for an example. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
