Re: Autonomous Transactions - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Autonomous Transactions
Date
Msg-id 1117642301.20484.72.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Autonomous Transactions  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-general
On Wed, 2005-06-01 at 10:52, Alvaro Herrera wrote:
> On Wed, Jun 01, 2005 at 03:38:01PM +0000, Matt Miller wrote:

> > I'm willing to use a different language, or even the libpq API if
> > necessary.
>
> If you really need autonomous transactions, you can establish an
> independent connection within a function in, say, PL/Perl or PL/Python.
> For example in PL/PerlU you can load the DBI driver and then use DBD::Pg
> to create another connection.  Any command and transaction you initiate
> on that other connection will be, of course, completely separate and
> independent from the connection the function is executing in.

I've done the same thing here at work with dblink.  Works a charm.

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Newby to DB
Next
From: Bruno Wolff III
Date:
Subject: Re: prevent user change password?