Re: Nested Transactions, Abort All

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