Autonomous transaction
От | Loïc Vaumerel |
---|---|
Тема | Autonomous transaction |
Дата | |
Msg-id | l2t5d2f25dc1004040726ica3a38d8x70c1685d2b096a7a@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Autonomous transaction
Re: Autonomous transaction Re: Autonomous transaction |
Список | pgsql-hackers |
Hi,
I have an application project based on a database.
I am really interested in using PostgreSQL.
I have only one issue, I want to use autonomous transactions to put in place a debug / logging functionality.
To do so, I insert messages in a "debug" table.
The problem is, if the main transaction / process rollback, my debug message insert will be rolled back too.
This is not the behavior I wish.
I need a functionality with the same behavior than the Oracle "PRAGMA AUTONOMOUS_TRANSACTION" one.
I have searched for it in the documentation and on the net, unfortunately nothing. (maybe I missed something)
I just found some posts regarding this :
... and some others ...
All solutions I found are working the same way : they use dblink.
I consider these solution more as handiwork than a clean solution.
I am a little bit concerned about side effects as dblink were not intially designed for this.
So my questions :
Is there a way to use real and clean autonomous transactions in PostgreSQL yet ?
If no, is it planned to do so ? When ?
Thanks in advance
Best regards
Shefla
В списке pgsql-hackers по дате отправления: