Re: Transactions within a function body

Coming from an Oracle background my understanding is they're one in the same.

 

 

On Thu, Oct 2, 2008 at 10:37 AM, Alvaro Herrera <alvherre@commandprompt.com> wrote:

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