[EMAIL PROTECTED] writes: > I did insert's with : > BEGIN TRANSACTION; > SET CONSTRAINTS ALL DEFERRED; > insert ... > END TRANSACTION;
> I get:
> ERROR: insert or update on table "transactions" violates foreign key
> constraint
SET CONSTRAINTS only affects those constraints that are marked
DEFERRABLE, which I believe is not the default.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
