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.