Re: autonomous transactions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: autonomous transactions
Date
Msg-id 26766.1201128602@sss.pgh.pa.us
Whole thread Raw
In response to Re: autonomous transactions  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: autonomous transactions  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
>> 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.

Seems like the cloning-a-session idea would be a possible implementation
path for these too.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: autonomous transactions
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: autonomous transactions