Re: Status of interactive psql's error handling? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Status of interactive psql's error handling?
Date
Msg-id 200506012140.j51LeVb29034@candle.pha.pa.us
Whole thread Raw
In response to Status of interactive psql's error handling?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark wrote:
>
> What's the current status on psql handling typos and interrupts more usefully
> by automatically encapsulating every statement in a savepoint? I'm just
> curious whether it's already in for 8.1 or if it got stalled.
>
> I ask because I just got bit again by a typo where I accidently deleted the
> wrong data and would dearly love to be able to start using autocommit=off so I
> can double check my ad-hoc database work before committing. I adopted this
> when I was working with Oracle and it saved my life more times than I can
> remember. But it's really not feasible if every typo requires starting from
> scratch.

psql in 8.1 will have:

    \set ON_ERROR_ROLLBACK interactive

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SRFs returning records from a view
Next
From: mark.lubratt@indeq.com
Date:
Subject: Re: SRFs returning records from a view