Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1723Ox72562 for ; Tue, 6 Feb 2001 21:03:25 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 70792 invoked by uid 89); 7 Feb 2001 02:03:20 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 7 Feb 2001 02:03:20 -0000 Received: by localhost with Microsoft MAPI; Tue, 6 Feb 2001 19:03:19 -0700 Message-ID: <01C0906F.782F0190.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Joseph Shraibman'" , "pgsql-sql@postgresql.org" Subject: RE: plpgsql error: cache lookup from pg_proc failed Date: Tue, 6 Feb 2001 19:03:14 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/106 X-Sequence-Number: 1284 Setting NEW in an AFTER update or insert trigger is not wise. Try using a before update trigger instead. -----Original Message----- From: Joseph Shraibman [SMTP:jks@selectacast.net] Sent: Tuesday, February 06, 2001 6:35 PM To: pgsql-sql@postgresql.org Subject: plpgsql error: cache lookup from pg_proc failed playpen=# create table aa( playpen(# a int, playpen(# b int, playpen(# t timestamp playpen(# ); CREATE playpen=# playpen=# playpen=# CREATE FUNCTION touch () RETURNS OPAQUE AS ' playpen'# BEGIN playpen'# new.t := current_timestamp; playpen'# RETURN new; playpen'# END; playpen'# ' LANGUAGE 'plpgsql'; CREATE playpen=# playpen=# playpen=# CREATE TRIGGER lastmod_1 AFTER update or insert ON aa FOR EACH ROW EXECUTE PROCEDURE touch(); CREATE playpen=# insert into aa (a, b) values (1,2); ERROR: plpgsql: cache lookup from pg_proc failed What does this error message mean? -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com