Re: autonomous transactions - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: autonomous transactions
Date
Msg-id CAJGNTeNCD1DgtG2KE_YsbCJbeBipLdFXZFHDYMUog7E+KO4T_w@mail.gmail.com
Whole thread Raw
In response to Re: autonomous transactions  (Joel Jacobson <joel@trustly.com>)
Responses Re: autonomous transactions  (Joel Jacobson <joel@trustly.com>)
List pgsql-hackers
On 30 August 2016 at 23:10, Joel Jacobson <joel@trustly.com> wrote:
>
> There should be a way to within the session and/or txn permanently
> block autonomous transactions.
>

This will defeat one of the use cases of autonomous transactions: auditing

>
> Coding conventions, rules and discipline are all good and will help
> against misuse of the feature, but some day someone will make a
> mistake and wrongly use the autonomous transaction and cause unwanted
> unknown side-effect I as a caller function didn't expect or know
> about.
>

well, if the feature is not guilty why do you want to put it in jail?

-- 
Jaime Casanova                      www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: ICU integration
Next
From: Michael Paquier
Date:
Subject: Re: standalone backend PANICs during recovery