On Sat, Jul 25, 2009 at 9:06 AM, Magnus Hagander<mag...@hagander.net> wrote: > On Saturday, July 25, 2009, Peter Eisentraut <pete...@gmx.net> wrote: >> When you run a file with psql -1/--single-transaction, and a command fails, >> you get bombarded with >> >> ERROR: current transaction is aborted, commands ignored until end of >> transaction block >> >> for the rest of the file. >> > > That would certainly be useful. > > Personally I'd prefer it to default to that always, and not just in > -1, but that would break way too many old things I'm afraid...
Doing it always would be really annoying. I often reload dumps that fail the grant statements but otherwise work. Admittedly, if I planned ahead, I could avoid having the grants be present in the dumps, but that would require planning ahead... But +1 for doing it when -1 is used. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers