Horton

Re: Nested Transactions, Abort All

Dennis Björklund <db@zigo.dhs.org>

View thread
From: Dennis Bjorklund <db@zigo.dhs.org>
To: Oliver Jowett <oliver@opencloud.com>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>, Thomas Swan <tswan@idigx.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-07-07T08:39:53Z
Lists: pgsql-hackers 
On Wed, 7 Jul 2004, Oliver Jowett wrote:

> So how do you propose supporting simple rollback of a subtransaction? It 
> seems like an extension regardless of how it's done.

If I understand you correctly what you want is a ROLLBACK TO SAVEPOINT
foo; followed by a RELEASE SAVEPOINT foo; 

-- 
/Dennis Björklund