Received: from work.ro ([193.231.126.196]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8CE5e786735 for ; Wed, 12 Sep 2001 10:05:40 -0400 (EDT) (envelope-from victor@work.ro) Message-Id: <200109121405.f8CE5e786735@postgresql.org> Received: (qmail 25433 invoked from network); 12 Sep 2001 14:05:36 -0000 Received: from unknown (HELO there) (192.168.1.37) by superman.localdomain with SMTP; 12 Sep 2001 14:05:36 -0000 Content-Type: text/plain; charset="iso-8859-1" From: victor Reply-To: victor@work.ro To: pgsql-sql@postgresql.org Subject: cache lookup failed Date: Wed, 12 Sep 2001 17:05:09 +0300 X-Mailer: KMail [version 1.3.5] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200109/60 X-Sequence-Number: 4706 Hi, I have this function: CREATE FUNCTION add_one (integer) RETURNS integer AS ' BEGIN RETURN $1 + 1; END; ' LANGUAGE 'plpgsql'; from postgres doc. When I try somethin like this: SELECT add_one(4); I get : ERROR: fmgr_info: function 20086: cache lookup failed please tell me what it's rong.