Re: Transactions within a function body - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Transactions within a function body
Date
Msg-id 20081002153737.GC4151@alvh.no-ip.org
Whole thread Raw
In response to Re: Transactions within a function body  ("Bob Henkel" <bob.henkel@gmail.com>)
Responses Re: Transactions within a function body  ("Bob Henkel" <bob.henkel@gmail.com>)
List pgsql-general
Bob Henkel escribió:
> Have you looked at creating a function in perl and creating a new
> connection? Or using a dblink query which can create a new connection?
> These two methods work. I have used them to insert to a log table regardless
> of the parent transaction being commited or rolled back.

That's a different thing, "autonomous transactions".

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Matthew Terenzio"
Date:
Subject: Re: tsearch 2 query
Next
From: Alvaro Herrera
Date:
Subject: Re: Transactions within a function body