Re: Autonomous transaction

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Loïc Vaumerel <shefla(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autonomous transaction
Date: 2010-04-06 11:35:49
Message-ID: 87wrwk3jai.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Loïc Vaumerel <shefla(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-04-06 11:39:20 Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per
Previous Message Heikki Linnakangas 2010-04-06 11:30:31 Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per