Cache lookup failed with FUNCTION + TRIGGER

From: Stéphane FILLON <fillons(at)offratel(dot)nc>
To: "pgsql sql" <pgsql-sql(at)postgreSQL(dot)org>, "pgsql admin" <pgsql-admin(at)postgreSQL(dot)org>
Subject: Cache lookup failed with FUNCTION + TRIGGER
Date: 1999-08-04 03:21:57
Message-ID: 000201bede95$30933640$c40a8280@portable
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-08-04 09:22:53 Re: [SQL] datetime sample code?
Previous Message Ramanika 1999-08-04 01:47:29 referential integrity