Re: Nested Transactions, Abort All - Mailing list pgsql-hackers

From Oliver Jowett
Subject Re: Nested Transactions, Abort All
Date
Msg-id 40EBA79B.7000101@opencloud.com
Whole thread Raw
In response to Re: Nested Transactions, Abort All  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: Nested Transactions, Abort All  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
Dennis Bjorklund wrote:
> On Tue, 6 Jul 2004, Alvaro Herrera wrote:
> 
> 
>>We can later implement savepoints, which will have "SAVEPOINT foo" and
>>"ROLLBACK TO foo" as interface.  (Note that a subtransaction is slightly
>>different from a savepoint, so we can't use ROLLBACK TO <foo> in
>>subtransactions because that has a different meaning in savepoints).
> 
> 
> What is the semantic difference?

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'.

-O


pgsql-hackers by date:

Previous
From: Honza Pazdziora
Date:
Subject: Re: Nested Transaction TODO list
Next
From: Andreas Pflug
Date:
Subject: Re: ALTER xx SET TABLESPACE (was bug in DROP TABLESPACE)