Postgres Pro
Downloads
Home   >   mailing lists

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

From Marko Tiikkaja
Subject Re: feature request: auto savepoint for interactive psql when in transaction.
Date
Msg-id 4E835BEF.5070802@2ndquadrant.com
Whole thread Raw
In response to feature request: auto savepoint for interactive psql when in transaction.  (Will Leinweber <will@heroku.com>)
Responses Re: feature request: auto savepoint for interactive psql when in transaction.
List pgsql-hackers
Tree view 
On 28/09/2011 02:57, Will Leinweber wrote:
> psql console, while in a transaction, and while in interactive mode,
> should savepoint for me.

You are lucky, since that feature has been in psql for some time 
already.  Simply add this to your .psqlrc:

\set ON_ERROR_ROLLBACK on


-- 
Marko Tiikkaja                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Gurjeet Singh
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.