Re: Autonomous Transactions - Mailing list pgsql-general

From Matt Miller
Subject Re: Autonomous Transactions
Date
Msg-id 1117832861.7993.51.camel@dbamm01-linux
Whole thread Raw
In response to Re: Autonomous Transactions  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Autonomous Transactions  (Matt Miller <mattm@epx.com>)
List pgsql-general
> > a way to enable a function to commit a unit of work that
> > does not affect the caller's transaction.

> Is dblink a possible answer?  (it's a contrib package.)

Very interesting.  When you earlier mentioned dblink I found only
DBLink-TDS on pgFoundry, and I dismissed it since I'm not accessing
MSSQL.

So, your idea is that I accomplish autonomous transactions in PL/pgSQL
by just using dblink_connect, dblink_open, dblink_exec, and
dblink_close?

This looks promising.  I'll give it a try.

pgsql-general by date:

Previous
From: Peter Fein
Date:
Subject: Re: Preventing Multiple Inheritance
Next
From: Bob
Date:
Subject: Re: postgresql books