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

Problem with insert

From: "Steven Lambert" <s(dot)lambert(at)madeware(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem with insert
Date: 2007-03-05 15:02:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
<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&nbsp;we must go in production tomorrow and we don&#39;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:&nbsp; 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&nbsp;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&eacute;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 />&nbsp;AS $BODY$</span><span style="font-size: 9pt; font-family: Arial">&nbsp;INSERT INTO Brieflayout<br />&nbsp;( brl_emailbrief<br />&nbsp;, brl_voor<br />&nbsp;, brl_omschrijving <br />&nbsp;, brl_actief_jn <br />&nbsp;, brl_blob_oid <br />&nbsp;, brl_typebrief <br />&nbsp;, brl_abf_id <br />&nbsp;, brl_ingangsatum <br />&nbsp;, brl_opmerking <br />&nbsp;, brl_margerechts<br />&nbsp;, brl_margelinks<br />&nbsp;, brl_margeboven<br />&nbsp;, brl_margeonder<br />&nbsp;, 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 &#39;sql&#39; VOLATILE;</span><span><font face="Times New Roman" size="3">&nbsp;</font></span> <p>Already thank you,<br />greetings,<br />Steven Lambert</p>

Attachment: unknown_filename
Description: text/html (1.9 KB)

pgsql-bugs by date

Next:From: BrunoDate: 2007-03-05 17:58:17
Subject: BUG #3111: PostgreSQL Driver is compatible with Win2003 Server 64 bits?
Previous:From: Randy IsbellDate: 2007-03-05 14:33:56
Subject: BUG #3110: Online Backup introduces Duplicate OIDs

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