Re: disable triggers using psql

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

> psql:test.sql:11: ERROR: current transaction is aborted, commands
> ignored until end of transaction block

Oops my bad, I forgot to tell you I have
\set ON_ERROR_ROLLBACK on
in my .psqlrc. So you'll need to add that to the top of
the script. Or just comment out the first insert and
see if the second one works. If it doesn't, something weird
is going on with Postgres. If it does, something weird is
going on with your script and I would recommend breaking your
dump script down into smaller pieces to see what is happening.
Most likely session_replication_role is not getting set or
is getting reset somewhere.

- --
Greg Sabino Mullane greg(at)endpoint(dot)com greg(at)turnstep(dot)com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 201102172155
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk1d360ACgkQvJuQZxSWSsidCQCfTnQxp5w6psa3C9NREX0ecZ+j
Ft0An2JKofuxVJNwxhVkh4NBTJU3Xcom
=fLDa
-----END PGP SIGNATURE-----