| 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: | Whole Thread | Raw Message | 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 |