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

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

From: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
To: Will Leinweber <will(at)heroku(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:39:59
Message-ID: 4E835BEF.5070802@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2011-09-28 17:43:09
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.
Previous:From: Gurjeet SinghDate: 2011-09-28 17:30:22
Subject: Re: feature request: auto savepoint for interactive psql when in transaction.

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