Re: BUG #16535: Implementing Autonomous Transactions in Postgresql

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16535: Implementing Autonomous Transactions in Postgresql
Дата
Msg-id CAKFQuwaAk7=9jbfAZTUL0_2UD_fACHTcUz+foPym2wr-CnnkLA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16535: Implementing Autonomous Transactions in Postgresql  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Fri, Jul 10, 2020 at 2:39 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16535
Logged by:          Isha Sonal
Email address:      ishasonal1841@yahoo.com
PostgreSQL version: 11.0
Operating system:   unix
Description:       

Not really a bug report, questions like this are better directed to the -general list.
I am trying to enable logging / auditing / progress tracking feature even if
my all transactions are rollbacked back. I tried to handle it with
procedures but its not working. Please suggest how can i achieve this
feature in PostgreSQL 11.

I've seen dblink recommended for this purpose.  In short you break out of the transaction by opening a new connection to the current database from inside the database and do your non-transactional work on it.

https://www.postgresql.org/docs/11/dblink.html

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: BUG #16535: Implementing Autonomous Transactions in Postgresql
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: BUG #16535: Implementing Autonomous Transactions in Postgresql