Skip site navigation (1) Skip section navigation (2)

Re: feature request: auto savepoint for interactive psql when in transaction.

From: Will Leinweber <will(at)heroku(dot)com>
To: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.
Date: 2011-09-28 17:51:38
Message-ID: CAL8LqZR5DsMOjsp8pAHObd4zAf9_TP1Z29063NbEO=dJW2y_OA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Sep 28, 2011 at 10:39 AM, Marko Tiikkaja
<marko(dot)tiikkaja(at)2ndquadrant(dot)com> wrote:
>  Simply add this to your .psqlrc:
>
> \set ON_ERROR_ROLLBACK on


Thank you Marko and Alvaro for pointing me in the right direction. I
set it to 'interactive', which I think makes the most sense.

I do wish this behavior was a little more discoverable, even though it
is in the manual.

—Will

In response to

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2011-09-28 17:56:18
Subject: Re: Updated version of pg_receivexlog
Previous:From: Kevin GrittnerDate: 2011-09-28 17:51:21
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group