Tr: Cache lookup failed with FUNCTION + TRIGGER

Started by Stéphane FILLONalmost 27 years ago1 messagesgeneral
Jump to latest
#1Stéphane FILLON
fillons@offratel.nc

-----Message d'origine-----
De : St�phane FILLON <fillons@offratel.nc>
� : pgsql sql <pgsql-sql@postgresql.org>; pgsql admin
<pgsql-admin@postgresql.org>
Date : mercredi 4 ao�t 1999 14:21
Objet : Cache lookup failed with FUNCTION + TRIGGER

Show quoted text

I have one table client :

create table client(
nocli int4,
....
);

create function client() returns opaque as '
begin
if new.nocli ISNULL then
raise exception "nocli null";
end if;
end;
' language 'plpgsql';

create trigger client before insert on client
for each row execute procedure client();

When I try to insert a tuple in client I have the following error:

"ERROR: fmgr_info: function 149857: cache lookup failed"

Where does this come from ? That's not the first time that I have this kind
of message!!

Please H E L P !!!!

RedHat 5.2
PostgreSQL 6.5.1

Regards,

Stephane FILLON