deferrable foreign keys - Mailing list pgsql-general

From Morus Walter
Subject deferrable foreign keys
Date
Msg-id 20091202152921.0b939407@tucholsky.experteer.de
Whole thread Raw
Responses Re: deferrable foreign keys  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: deferrable foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

are there downsides of making foreign keys deferrable (but initially
immediate) for updates, when the transaction does not set the
constraint behaviour to deferred?

I'd expect that to have the same behaviour as non deferrable foreign
keys.
What I don't understand is, why is non deferrable the default, then.

So maybe I miss something.

regards
    Morus

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Large Objects and Replication question
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: deferrable foreign keys