Re: Nested Transactions, Abort All

Scott Marlowe <smarlowe@qwest.net>

From: "Scott Marlowe" <smarlowe@qwest.net>
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-07T15:26:07Z
Lists: pgsql-hackers
On Wed, 2004-07-07 at 00:16, 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?

One is in the SQL spec?

For that reason alone, we should probably eventually have the savepoint
syntax work.