Received: from mail.offratel.nc (FS25.offratel.nc [209.58.55.25]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA91388; Wed, 4 Aug 1999 12:20:28 -0400 (EDT) (envelope-from fillons@offratel.nc) Received: from portable (unverified [209.58.55.138]) by mail.offratel.nc (Rockliffe SMTPRA 3.3.1) with SMTP id ; Thu, 5 Aug 1999 03:20:28 +1100 Message-ID: <000201bede95$30933640$c40a8280@portable> Reply-To: "=?iso-8859-1?Q?St=E9phane_FILLON?=" From: "=?iso-8859-1?Q?St=E9phane_FILLON?=" To: "pgsql sql" , "pgsql admin" Subject: Cache lookup failed with FUNCTION + TRIGGER Date: Wed, 4 Aug 1999 14:21:57 +1100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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