Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes: > I'm not sure what's really happening but why apparently the delete > statements get executed before the 2 inserts even if constraints are > deferred?
You didn't mark the FK constraints as deferrable --- I'm pretty sure the default is NOT DEFERRABLE. > Why does it take so long? Indexes on the FK columns would probably help. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general