<span style="font-size: 9pt; font-family: Arial">Hello,<br /><br />We have a Postgresql 8.1.8 and a problem, probably no bug.<br />But we must go in production tomorrow and we don't know where to look to solve this. Therefore I hope somebody can help us.<br /><br />The problem is when we insert with a function, we get the message <br /><br />SQLSTATE = 25P02<br />Error while executing the query;<br />ERROR: current transaction is aborted, commands ignored until end of transaction block</span><span style="font-size: 9pt; font-family: Arial">No changes made to database.</span><span style="font-size: 9pt; font-family: Arial">execute public.spr_ins_brieflayout <br /><br />When we do the insert directly again it goes fine, very strange. Other functions are going good, insert, update and delete.<br /><br />This is the function, other functions like this one goes perfect? Does anybody have an idée where we have to look, to solve it.<br /><br />CREATE OR R!
EPLACE FUNCTION public.spr_ins_brieflayout<br />( IN char, IN varchar, IN varchar, IN char, IN varchar, IN varchar<br />, IN numeric, IN date, IN text, IN numeric, IN numeric, IN numeric, IN numeric, IN numeric) RETURNS void<br /> AS $BODY$</span><span style="font-size: 9pt; font-family: Arial"> INSERT INTO Brieflayout<br /> ( brl_emailbrief<br /> , brl_voor<br /> , brl_omschrijving <br /> , brl_actief_jn <br /> , brl_blob_oid <br /> , brl_typebrief <br /> , brl_abf_id <br /> , brl_ingangsatum <br /> , brl_opmerking <br /> , brl_margerechts<br /> , brl_margelinks<br /> , brl_margeboven<br /> , brl_margeonder<br /> , mut_mede_nr)<br />VALUES ($1,$2,$3,$4,lo_import($5),$6,$7,$8,$9,$10,$11,$12,$13,$14);<br />$BODY$<br />LANGUAGE 'sql' VOLATILE;</span><span><font face="Times New Roman" size="3"> </font></span> <p>Already thank you,<br />greetings,<br />Steven Lambert</p>