| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Matt Miller <mattm(at)epx(dot)com> |
| Cc: | PostgreSQL - GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Autonomous Transactions |
| Date: | 2005-06-03 23:23:28 |
| Message-ID: | 1117841008.5758.90.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2005-06-03 at 18:04, Matt Miller wrote:
> > > a way to enable a function to commit a unit of work that
> > > does not affect the caller's transaction.
>
> > accomplish autonomous transactions in PL/pgSQL
> > by just using dblink_connect, dblink_open, dblink_exec,
> > and dblink_close?
>
> My initial tests lead me to believe that dblink is a simple and
> effective way to get anonymous transactions.
We've used them at work for autonomous transactions outside of plpgsql.
Not sure of how well they would or wouldn't work inside plpgsql.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-06-03 23:25:02 | Re: Old problem needs solution |
| Previous Message | Greg Stark | 2005-06-03 23:05:07 | Re: Determining when a row was inserted |