Re: Autonomous transaction - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Autonomous transaction
Date
Msg-id 87wrwk3jai.fsf@hi-media-techno.com
Whole thread Raw
In response to Autonomous transaction  (Loïc Vaumerel <shefla@gmail.com>)
List pgsql-hackers
Loïc Vaumerel <shefla@gmail.com> writes:
> 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.

See plproxy which is designed for this kind of work. Or about…

> Is there a way to use real and clean autonomous transactions in
> PostgreSQL yet ?

None that I know of.

> If no, is it planned to do so ? When ?

We get demands quite often, it seems it's one of the "big tickets" we're
still missing. I don't remember any development effort proposal, though.

Regards,
--
dim


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per
Next
From: Heikki Linnakangas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per