Re: feature request: auto savepoint for interactive psql when in transaction. - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: feature request: auto savepoint for interactive psql when in transaction.
Date
Msg-id 20110928192258.GZ12765@tamriel.snowman.net
Whole thread Raw
In response to Re: feature request: auto savepoint for interactive psql when in transaction.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: feature request: auto savepoint for interactive psql when in transaction.
List pgsql-hackers
* Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
> Alvaro Herrera <alvherre@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

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.
Next
From: Alvaro Herrera
Date:
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.