[postgis-users] [GENERAL] Basic question on PGSQL and Transactions

[Henri De Feraudy]

I just tried putting commit work inside a PL/PGSQL function insert_my_data() and 
then tried 
calling this function. I got a runtime error.




________________________________
From: Alban Hertroys <dalroi at solfertje.student.utwente.nl>
To: Henri De Feraudy <feraudyh at yahoo.com>
Cc: pgsql-general at postgresql.org
Sent: Wed, September 29, 2010 7:04:52 PM
Subject: Re: [GENERAL] Basic question on PGSQL and Transactions

On 29 Sep 2010, at 18:31, Henri De Feraudy wrote:

> I mean, if you are inserting into a table from PLPGSQL do you have to do an 
> explicit commit at some stage?

I suppose you meant psql here, as otherwise the above statement wouldn't make 
sense ;)

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:1175,4ca371bc678302094595771!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100929/4a12e08e/attachment.html>