Re: autonomous transactions - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: autonomous transactions
Date
Msg-id CAASwCXcOKAzLp77WP10LV_0aiQuJxhd_BM2V_ey4FNY=iTQm4Q@mail.gmail.com
Whole thread Raw
In response to Re: autonomous transactions  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Thu, Sep 1, 2016 at 8:38 PM, Andres Freund <andres@anarazel.de> wrote:
>
> I'm not convinced this makes much sense. All FDWs, dblink etc. already
> allow you do stuff outside of a transaction.

You as a DBA can prevent FDWs from being used and dblink is an
extension that you don't have to install.
So if preventing side-effects is necessary in your application, that
can be achieved by simply not installing dblink and preventing FDWs.



pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Sample configuration files
Next
From: Rahila Syed
Date:
Subject: Re: Surprising behaviour of \set AUTOCOMMIT ON