Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA53109 for ; Tue, 18 May 1999 12:52:23 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.uvsg.com ([192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id KVHZC2KT; Tue, 18 May 1999 11:52:39 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Tue, 18 May 1999 11:55:36 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC145511@lambic.prevuenet.com> From: Michael J Davis To: "'Adam H. Pendleton'" , pgsql-sql@hub.org Subject: RE: [SQL] Function and trigger problem Date: Tue, 18 May 1999 11:53:39 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Trigger functions must return OPAQUE (OLD or NEW). -----Original Message----- From: Adam H. Pendleton [SMTP:apendleton@vgsinc.com] Sent: Tuesday, May 18, 1999 10:25 AM To: pgsql-sql@hub.org Subject: [SQL] Function and trigger problem 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