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
