Re: Nested Transactions, Abort All

Oliver Jowett <oliver@opencloud.com>

From: Oliver Jowett <oliver@opencloud.com>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>, Thomas Swan <tswan@idigx.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-07-07T08:34:34Z
Lists: pgsql-hackers
Dennis Bjorklund wrote:
> On Wed, 7 Jul 2004, Oliver Jowett wrote:
> 
> 
>>Savepoint "ROLLBACK TO foo" doesn't invalidate 'foo'. If "SAVEPOINT foo" 
>>is 'start new subtransaction foo', "ROLLBACK TO foo" must be 'roll back 
>>subtransaction foo and all children; start new subtransaction foo'.
> 
> 
> If that is all there is, I much rather see this standard interface then a
> pg extension.

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

-O