On Jan 23, 2008 10:06 PM, Gokulakannan Somasundaram <gokul007(at)gmail(dot)com> wrote:
> On Jan 24, 2008 2:46 AM, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> > > The Audit transaction, which is a autonomous transaction need not catch
> > > error and resume the outer transaction.
> > What if the logging fails, say because you forgot to create the audit
> > table?
> I get it now...
Autonomous transactions are, umm, autonomous. The calling transaction
doesn't know about or care whether the autonomous transaction succeeds
or fails for any reason.
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/
In response to
pgsql-hackers by date
|Next:||From: Wes||Date: 2008-01-24 16:41:46|
|Subject: REINDEX on large DB vs. DROP INDEX/CREATE INDEX |
|Previous:||From: Gokulakannan Somasundaram||Date: 2008-01-24 03:06:56|
|Subject: Re: autonomous transactions|