Re: libpq on the server - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: libpq on the server
Date
Msg-id 20040823194346.GA17727@dcc.uchile.cl
Whole thread Raw
In response to Re: libpq on the server  (Wayne Fang <wayne@barrodale.com>)
List 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>)


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: UTF-8 and LIKE vs =
Next
From: Thomas Hallgren
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions