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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
