Hello,

We have a Postgresql 8.1.8 and a problem, probably no bug.
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.

The problem is when we insert with a function, we get the message

SQLSTATE = 25P02
Error 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

When we do the insert directly again it goes fine, very strange. Other functions are going good, insert, update and delete.

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.

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$ INSERT INTO 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,
Steven Lambert