| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Wayne Fang <wayne(at)barrodale(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: libpq on the server |
| Date: | 2004-08-23 19:43:46 |
| Message-ID: | 20040823194346.GA17727@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 23, 2004 at 12:28:26PM -0700, Wayne Fang wrote:
> As another consideration, SPI doesn't yet support transactions. Any idea
> when this support might come about?
Not soon. Any action that goes through SPI is using the same
transaction that it was initiated in. There's no way to meaningfully
close said transaction and keep the SPI function running.
In 8.0 you are able to use the savepoint feature through SPI, so you can
partially rollback if there is an error, take appropiate action and keep
going without having to start everything again. But it will be within
one transaction.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-08-23 19:52:56 | Re: Unsupported 3rd-party solutions (Was: Few questions |
| Previous Message | Tom Lane | 2004-08-23 19:41:55 | Re: Unsupported 3rd-party solutions (Was: Few questions |