| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
| Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Thomas Swan <tswan(at)idigx(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Nested Transactions, Abort All |
| Date: | 2004-07-07 07:34:51 |
| Message-ID: | 40EBA79B.7000101@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2004-07-07 07:44:18 | Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE) |
| Previous Message | Christopher Kings-Lynne | 2004-07-07 07:19:34 | Re: ALTER xxx SET TABLESPACE (was bug in DROP TABLESPACE) |