Problem with insert
От | Steven Lambert |
---|---|
Тема | Problem with insert |
Дата | |
Msg-id | 200703051502.l25F2xd4026607@server07.sylconia.nl обсуждение исходный текст |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: