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