Re: good exception handling archiecutre
Adrian von Bidder <avbidder@fortytwo.ch>
From: Adrian von Bidder <avbidder@fortytwo.ch>
To: pgsql-general@postgresql.org
Date: 2010-08-16T11:26:53Z
Lists: pgsql-general
Heyho!
[[ logging from postgres ]]
I think you can use dblink to do this - everything you do via dblink happens
in a separate db session and so it shouldn't be affected by what happens in
your transaction.
Depending on your requirements, system resources may be an issue though
(you're opening a full additional db session.)
cheers
-- vbi
--
Although this syntax is required by the SQL standard, it's not clear
what the standard expects it to do, except that it's most likely not
what we were doing.
-- PostgreSQL 8.3 release notes