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