Re: disable triggers using psql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> We were trying to accomplish this without having to hack the dump to
> much.  We attempted adding:
>
> set local session_replication_role = replica;
>
> But that does not seem provide the expected relief.

How exactly did this fail? This should absolutely disable all
triggers for you, unless you've mucked with the triggers
and set them to replica.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201102171053
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk1dRKIACgkQvJuQZxSWSsir0wCfQZmZkDrYBYVffyYBGYoqA/RT
VRMAoLG497FaRU7gOkpM394UT7xksXzk
=f9co
-----END PGP SIGNATURE-----