Hello,We have a Postgresql 8.1.8 and a problem, probably no bug.But we must go in production tomorrow and we
don'tknow where to look to solve this. Therefore I hope somebody can help us.The problem is when we insert with a
function,we get the message SQLSTATE = 25P02Error while executing the query;ERROR: current transaction is
aborted,commands ignored until end of transaction blockNo changes made to database.execute public.spr_ins_brieflayout
Whenwe do the insert directly again it goes fine, very strange. Other functions are going good, insert, update and
delete.Thisis the function, other functions like this one goes perfect? Does anybody have an idée where we have
tolook, to solve it.CREATE OR R!
EPLACE FUNCTION public.spr_ins_brieflayout( IN char, IN varchar, IN varchar, IN char, IN varchar, IN varchar, IN
numeric,IN date, IN text, IN numeric, IN numeric, IN numeric, IN numeric, IN numeric) RETURNS void AS
$BODY$ INSERTINTO Brieflayout ( brl_emailbrief , brl_voor , brl_omschrijving , brl_actief_jn
,brl_blob_oid , brl_typebrief , brl_abf_id , brl_ingangsatum , brl_opmerking ,
brl_margerechts ,brl_margelinks , brl_margeboven , brl_margeonder , mut_mede_nr)VALUES
($1,$2,$3,$4,lo_import($5),$6,$7,$8,$9,$10,$11,$12,$13,$14);$BODY$LANGUAGE'sql' VOLATILE; Already thank
you,greetings,StevenLambert
