Re: Autonomous Transactions

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.