Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
>> cut and paste:
>>
>> set ON_ERROR_ROLLBACK;
>
> Should be
>
> \set ON_ERROR_ROLLBACK on
>
> You can also set this when calling psql like so:
>
> psql --set ON_ERROR_ROLLBACK=on
>
> But that's getting off-topic now, as we've got the problem narrowed:
>
>> INSERT 0 1
>
> This shows the session_replication_role is working as it should. Double
> check where and how you are setting it; your foreign key problems
> will go away once it is set correctly.
Okay, thanks.
>
> - --
> Greg Sabino Mullane greg@turnstep.com
> End Point Corporation http://www.endpoint.com/
> PGP Key: 0x14964AC8 201102181243
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iEYEAREDAAYFAk1esCsACgkQvJuQZxSWSsh5JgCeK/Mk+e598LAhDsYvNmTCWM8E
> F+sAoN9YX32TFKF/5YDp3CoNBwfnbnqb
> =u8rB
> -----END PGP SIGNATURE-----
>
>
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651