Proc mi nefunguje trigger ?

[Karel Kral]

Mam problem pokud v PostgreSQLvytvorim funkci prevod() viz nize (s returns 0
int ) je vse v poradku a funkce dela co delat ma.
Pokud ji vsak chci spoustet jako trigger
dojde pri pokusu o zapis do tabulky logs k nasledujici chybe:

fmrg_info: function 3199837: cache lookup failed


Netusite kde je chyba


Dekuji !!!!!!!!!!



create function prevod()
returns OPAQUE
as '
begin

if (select position (''>'' in rule_name) from logs)
then insert into new_logs (rule_name,download,that_time) select
rtrim(rule_name,''-> ''),bytes,that_time from logs;
     delete from logs;
else
 update new_logs set upload =(select bytes from logs) where
that_time=(select that_time from logs);
 delete from logs;
end if;
return new;
end;'
language 'plpgsql';

create trigger tr_prevod after insert on logs for each row execute procedure
prevod();