Tr: Cache lookup failed with FUNCTION + TRIGGER

-----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


>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
>