On Fri, 2005-06-03 at 18:04, Matt Miller wrote: > > > a way to enable a function to commit a unit of work that > > > does not affect the caller's transaction. > > > accomplish autonomous transactions in PL/pgSQL > > by just using dblink_connect, dblink_open, dblink_exec, > > and dblink_close? > > My initial tests lead me to believe that dblink is a simple and > effective way to get anonymous transactions. We've used them at work for autonomous transactions outside of plpgsql. Not sure of how well they would or wouldn't work inside plpgsql. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org