From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>, Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Nested Transactions, Abort All |
Date: | 2004-07-09 20:32:20 |
Message-ID: | 1089405139.17493.653.camel@stromboli |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 2004-07-09 at 21:18, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > Oracle uses ROLLBACK TO SAVEPOINT...identical pretty much.
>
> I thouht ROLLBACK was different from RELEASE, no? I see ROLLBACK used
> in SQL99 for savepoints:
>
> ROLLBACK [ WORK ] [ AND [ NO ] CHAIN ]
> [ <savepoint clause> ]
>
>
> RELEASE only discards the savepoint name, I thought.
>
ERR-OHH Yes, dead right. Forgive my confusion, I knew there was
something different about Oracle's support of RELEASE. Check out:
https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10759/ap_standard_sql001.htm
last thing on page...
> > Oracle's support of autonomous transactions looks to be identical to
> > nested transactions (Alvaro's advice required there...). They don't
> > allow you to explicitly call them, but you can use BEGIN/COMMIT in a
> > host program that calls a stored procedure, which also contains
> > BEGIN/COMMIT, effectively giving nested txns.
>
> Oracle has nested transactions too? Can you supply an example?
It's hard to quote a short example.... so try this link instead
http://www.hk8.org/old_web/oracle/guide8i/ch02_05.htm
Wasn't there some description of autonomous transactions on the stuff I
sent previously?
Best Regards, Simon Riggs
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-09 20:42:18 | fix schema ownership on first connection preliminary patch v2 |
Previous Message | Bruce Momjian | 2004-07-09 20:18:43 | Re: Nested Transactions, Abort All |