* Kevin Grittner (kevin.gritt...@wicourts.gov) wrote: > Alvaro Herrera <alvhe...@commandprompt.com> wrote: > > See ON_ERROR_ROLLBACK > > http://www.postgresql.org/docs/9.0/static/app-psql.html > > I had missed that. Dang, this database product is rich with nice > features! :-)
Be careful when running scripts, however.. Any invocation of psql will read you .psqlrc and if you've got ON_ERROR_ROLLBACK set there then psql -f blah ; will pick up on that and you'll end up running every command in the script (including the commit at the end...), even if some of the commands in it failed. So, if you put it in your .psqlrc, be VERY sure that you UN-set it on the command-line whenever running SQL scripts which *should* rollback on failures.. Thanks, Stephen
signature.asc
Description: Digital signature