From: Stéphane FILLON <fillons@offratel.nc>
To: pgsql sql <pgsql-sql@postgreSQL.org>
To: pgsql admin <pgsql-admin@postgreSQL.org>
Subject: Cache lookup failed with FUNCTION + TRIGGER
Date: Wed, 4 Aug 1999 14:21:57 +1100
Message-ID: <000201bede95$30933640$c40a8280@portable> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: fillons@offratel.nc, pgsql-admin@postgreSQL.org
Subject: Re: Cache lookup failed with FUNCTION + TRIGGER
In-Reply-To: <000201bede95$30933640$c40a8280@portable>
References: <000201bede95$30933640$c40a8280@portable>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox