"Neil Conway" <neilc(at)samurai(dot)com> writes:
> 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.
I think the hard part would be error handling. You have to be able to catch
any errors and resume the outer transaction.
Ask me about EnterpriseDB's 24x7 Postgres support!
In response to
pgsql-hackers by date
|Next:||From: Michael Meskes||Date: 2008-01-23 10:24:41|
|Subject: Re: Errors with run_build.pl - 8.3RC2|
|Previous:||From: Pavel Stehule||Date: 2008-01-23 09:05:50|
|Subject: Re: autonomous transactions|