Re: [HACKERS] psql: ON_ERROR_STOP command-line flag for scripts

2010-06-07 Thread Stephen Frost
* Mike Toews (mwto...@gmail.com) wrote: > I know I can either embed a non-SQL command in the SQL file or add > --set ON_ERROR_STOP =1 to the command arguments, however I'd like a > simpler command interface (just like there is -q / --quiet for QUIET). > Could I suggest a new command-line option -r

[HACKERS] psql: ON_ERROR_STOP command-line flag for scripts

2010-06-07 Thread Mike Toews
Hey hackers, I routinely run SQL scripts using pgsql -f myscript.sql. If there is an error mid-way in a large script file, due to the default ON_ERROR_STOP=0, I see repeated "ERROR:  current transaction is aborted, commands ignored until end of transaction block" until the end of the script. Often