-----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@xxxxxxxxxxxx greg@xxxxxxxxxxxx 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
