Received: from proxy.vgs.com (proxy.vgsinc.com [209.48.221.10]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA50350 for ; Tue, 18 May 1999 12:25:47 -0400 (EDT) (envelope-from apendleton@vgsinc.com) Received: from fms13.belvoir.army.mil by proxy.vgs.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.0.1460.8) id K8KM782B; Tue, 18 May 1999 12:33:46 -0400 Message-ID: <000f01bea14b$079ef670$bdd0be80@belvoir.army.mil> From: "Adam H. Pendleton" To: References: <19391.927040305@sss.pgh.pa.us> Subject: Function and trigger problem Date: Tue, 18 May 1999 12:25:22 -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 use the following code to create a function: create function employee_stats_update() returns int4 as 'insert into employee_stats values ( new.employee_name); select 1 as ignore_this' language 'plpgsql'; Then I create the following trigger: create trigger update_employee_stats before insert on employee_master for each row execute procedure employee_stats_update(); This is what I get back when I try to create the trigger: ERROR: CreateTrigger: function employee_stats_update () does not exist Adam