Re: BUG #16535: Implementing Autonomous Transactions in Postgresql - Mailing list pgsql-bugs

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:        

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 am currently working on Oracle DB and using Autonomous Transactions to
enable logging feature.

Autonomous transactions are supported in PgPro-EE (Postgres Professional clone of Postgres).
In vanilla autonomous transaction can be simulated using dblink - extension providing connections to PostgreSQL database from within a database session.