Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAEG6ws45177 for ; Tue, 14 Nov 2000 11:06:58 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eAEG5dD02625; Tue, 14 Nov 2000 11:05:39 -0500 (EST) To: "Graham Vickrage" cc: pgsql-sql@postgresql.org Subject: Re: Trigger cant find function In-reply-to: References: Comments: In-reply-to "Graham Vickrage" message dated "Tue, 14 Nov 2000 13:36:15 +0000" Date: Tue, 14 Nov 2000 11:05:39 -0500 Message-ID: <2622.974217939@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/108 X-Sequence-Number: 139 "Graham Vickrage" writes: > ERROR: CreateTrigger: function get_prod_cost_price() does not exist > It is clear that it does exist so why does the trigger creation code not > find it? Because the code is looking for a function of no arguments, which yours is not. The method for dealing with arguments passed to triggers is, um, arcane --- I think you look in an implicitly declared array named TGARG, or something like that. You don't receive them as normal function arguments, anyway. regards, tom lane