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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general