[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] [GENERAL] Basic question on PGSQL and
From: Henri De Feraudy <feraudyh () yahoo ! com>
Date: 2010-09-29 18:56:37
Message-ID: 393472.82276.qm () web110810 ! mail ! gq1 ! yahoo ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@solfertje.student.utwente.nl>
To: Henri De Feraudy <feraudyh@yahoo.com>
Cc: pgsql-general@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!
[Attachment #5 (text/html)]
<html><head><style type="text/css"><!-- DIV {margin:0px;} \
--></style></head><body><div style="font-family:'Courier New', courier, monaco, \
monospace, sans-serif;font-size:12pt"><div>I just tried putting commit work inside a \
PL/PGSQL function insert_my_data() and then tried </div><div>calling this \
function. I got a runtime error.</div><div><br></div><div style="font-family:Courier \
New, courier, monaco, monospace, sans-serif;font-size:12pt"><br><div \
style="font-family:arial, helvetica, sans-serif;font-size:13px"><font size="2" \
face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Alban \
Hertroys <dalroi@solfertje.student.utwente.nl><br><b><span style="font-weight: \
bold;">To:</span></b> Henri De Feraudy <feraudyh@yahoo.com><br><b><span \
style="font-weight: bold;">Cc:</span></b> pgsql-general@postgresql.org<br><b><span \
style="font-weight: bold;">Sent:</span></b> Wed, September 29, 2010 7:04:52 \
PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [GENERAL] Basic \
question on PGSQL and Transactions<br></font><br> On 29 Sep 2010, at 18:31, Henri De \
Feraudy wrote:<br><br>> I mean, if you are inserting into a table from PLPGSQL do \
you have to do an <br>> explicit commit at some stage?<br><br>I suppose you meant \
psql here, as otherwise the above statement wouldn't make sense ;)<br><br>Alban \
Hertroys<br><br>--<br>Screwing up is an excellent way to attach something to the \
ceiling.<br><br><br>!DSPAM:1175,4ca371bc678302094595771!<br><br><br></div></div><div \
style="position:fixed"></div>
</div></body></html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic