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

From Daniel Farina
Subject Re: feature request: auto savepoint for interactive psql when in transaction.
Date
Msg-id CAAZKuFY_SDZyG0K5_WaGbiVw=Or18RCnfyfzoZHZ__4YwfR1LQ@mail.gmail.com
Whole thread Raw
In response to Re: feature request: auto savepoint for interactive psql when in transaction.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Wed, Sep 28, 2011 at 1:02 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> wrote:
>
>>> ON_ERROR_ROLLBACK ["on" can be a problem in a script file]
>
>> So set it to "interactive".
>
> I think we have an opportunity for a documentation enhancement there.

In the same vein, I think there may also be some room for
discoverability enhancements here in psql, too: I've been using psql
for years and just compensated for want of this feature by being very
careful or annoyed (when that didn't work out).  I never knew about this.

Something along the lines of the HINT message emitted from the server,
but I do not know if client-side psql has any prior art for that.

-- 
fdr


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Feature proposal: www_fdw
Next
From: Bruce Momjian
Date:
Subject: Re: fix for pg_upgrade