From:
Simon Riggs <simon(at)2ndquadrant(dot)com>
To:
Neil Conway <neilc(at)samurai(dot)com>
Cc:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
"Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>,
"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: autonomous transactions
Date:
2008-01-23 21:32:59
Message-ID:
1201123979.4257.50.camel@ebony.site (view raw or flat )
Thread:
2008-01-22 16:02:44 from "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
2008-01-22 18:53:53 from Neil Conway <neilc(at)samurai(dot)com>
2008-01-22 19:04:16 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-22 19:53:59 from "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
2008-01-23 08:13:55 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-23 09:05:50 from "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
2008-01-29 16:12:25 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-01-29 16:14:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-01-30 17:04:28 from Josh Berkus <josh(at)agliodbs(dot)com>
2008-01-30 17:11:14 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-23 08:26:52 from Neil Conway <neilc(at)samurai(dot)com>
2008-01-23 09:30:54 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-23 20:47:50 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-23 21:16:47 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-24 03:06:56 from "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
2008-01-24 03:35:22 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2008-01-23 22:35:32 from Neil Conway <neilc(at)samurai(dot)com>
2008-01-23 21:32:59 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-01-23 22:50:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-25 06:27:40 from Decibel! <decibel(at)decibel(dot)org>
2008-01-28 21:33:05 from "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
2008-01-29 07:52:39 from Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
2008-01-24 22:37:04 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Lists:
pgsql-hackers
On Wed, 2008-01-23 at 00:26 -0800, Neil Conway wrote:
> On Tue, 2008-01-22 at 20:53 +0100, Pavel Stehule wrote:
> > And there is most important question about data visibility - is
> > autonomous transaction independent on main transaction (isolation)?
>
> >From looking at how Oracle does them, autonomous transactions are
> completely independent of the transaction that originates them -- they
> take a new database snapshot. This means that uncommitted changes in the
> originating transaction are not visible to the autonomous transaction.
Oh! Recursion depth would need to be tested for as well. Nasty.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
In response to
Responses
pgsql-hackers by date
Next :From: Neil ConwayDate: 2008-01-23 22:35:32Subject : Re: autonomous transactionsPrevious :From : Jonah H. HarrisDate : 2008-01-23 21:19:18Subject : Re: [HACKERS] Including Snapshot Info with Indexes
