Re: autonomous transactions

On Tuesday 22 January 2008 11:02, Roberts, Jon wrote:
> I really needed this functionality in PostgreSQL.  A common use for
> autonomous transactions is error logging.  I want to log sqlerrm in a
> function and raise an exception so the calling application knows there is
> an error and I have it logged to a table.
>
>
>
> I figured out a way to "hack" an autonomous transaction by using a dblink
> in a function and here is a simple example:
>
>
>

This is an enhanced version of the "hack", maybe it will be of some help... 
https://labs.omniti.com/trac/pgsoltools/browser/trunk/autonomous_logging_tool

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL