Prestation3.EXPLOITATION@xxxxxxxxxx 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
