Received: from proxy.vgs.com (proxy.vgsinc.com [209.48.221.10])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA88281
	for <pgsql-sql@hub.org>; Wed, 12 May 1999 09:40:17 -0400 (EDT)
	(envelope-from apendleton@vgsinc.com)
Received: from fms54.belvoir.army.mil by proxy.vgs.com with SMTP (Microsoft
	Exchange Internet Mail Service Version 5.0.1460.8)
	id KZ1RR92S; Wed, 12 May 1999 09:47:46 -0400
Message-ID: <005501be9c7c$fde98550$bdd0be80@belvoir.army.mil>
From: "Adam H. Pendleton" <apendleton@vgsinc.com>
To: <pgsql-sql@hub.org>
Subject: Function error
Date: Wed, 12 May 1999 09:40:24 -0400
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 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

I created the following function:

create function employee_pay_update() returns opaque as '
 begin
   insert into employee_payroll values (
   new.employee_id,
   new.employee_name
   );
 ' language 'plpgsql';

This is just supposed to insert any record inserted into a table into
employee_payroll.  I don't need any sort of error checking as that will be
done elsewhere.  When I try to insert into the first table, and the trigger
calls this function I get this error:

java.sql.SQLException: ERROR:  fmgr_info: function 19265: cache lookup
failed

Did I forget to do something?

Adam



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Si hoc legere scis nimium eruditionis habes.