Re: Transactions and Exceptions

Bart Degryse wrote:
>> 2. Using dblink / dbi-link to reconnect to the database, which means 
>> your logging will take place in its own transaction.
> This I like more. Though I don't use either dblink nor dbi-link, I do use this kind of 
> 'double' connections already for other purposes in which transactions were never an 
> issue. So it never crossed my mind that I could use them for this too.
> For the time being that's the way I'll walk. Thanks a lot!
>  
> Reading your suggestions I assume PostgreSQL lacks something like Oracle's
> PRAGMA AUTONOMOUS_TRANSACTION

It might well be a useful feature (particularly for logging-style 
interactions as you have). I'm not sure it's particularly simple to do 
(other than by having a whole new backend as dblink will give you).

> Shouldn't it be added, are there any plans in that direction? Returning a status code
> is not always an option and using some dbi variant certainly isn't because of the 
> need for perlu. So then you're stuck?!

Well, dblink is pure C iirc. I think the advantage with dbi-link is that 
you can connect to any type of database DBI can.

--   Richard Huxton  Archonet Ltd