Cache lookup failed with FUNCTION + TRIGGER - Mailing list pgsql-sql

From Stéphane FILLON
Subject Cache lookup failed with FUNCTION + TRIGGER
Date
Msg-id 000201bede95$30933640$c40a8280@portable
Whole thread Raw
Responses Re: [SQL] Cache lookup failed with FUNCTION + TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Howie
Date:
Subject: Re: [SQL] referential integrity
Next
From: astromonk
Date:
Subject: sequences not reliable?