From:
Neil Conway <neilc(at)samurai(dot)com>
To:
Gregory Stark <stark(at)enterprisedb(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
Subject:
Re: autonomous transactions
Date:
2008-01-23 22:35:32
Message-ID:
1201127732.15243.10.camel@dell.linuxdev.us.dell.com (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 09:30 +0000, Gregory Stark wrote:
> I think the hard part would be error handling. You have to be able to catch
> any errors and resume the outer transaction.
I agree that you'd need to do this, but I don't follow why it would be
particularly difficult. You essentially have a stack of active
transactions (since one autonomous transaction can start another
autonomous transaction, and so forth). If you encounter an error in the
current transaction, you abort it as normal, pop the stack, and resume
execution of the originating transaction.
I think the hard part is fixing the parts of the backend that assume
that a single process can only have a single top-level transaction in
progress at a given time.
-Neil
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2008-01-23 22:50:02Subject : Re: autonomous transactions Previous :From : Simon RiggsDate : 2008-01-23 21:32:59Subject : Re: autonomous transactions
