Thanks for looking into this! I tried your workaround on both 9.3.6 and 9.4.1 on Windows (64-bit), but it made no difference for me. If I put the SET TRANSACTION statement before BEGIN on 9.4.1 I get "WARNING: SET TRANSACTION can only be used in transaction blocks" - but putting it inside the transaction block doesn't prevent the constraint violation, either.
On 28/04/2015 2:16 PM, John McKown wrote: