Skip site navigation (1) Skip section navigation (2)

Re: libpq on the server

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 (view raw or flat)
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>)


In response to

pgsql-general by date

Next:From: Marc G. FournierDate: 2004-08-23 19:52:56
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:From: Tom LaneDate: 2004-08-23 19:41:55
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group