<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>