Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id CAA58252 for ; Fri, 14 Apr 2000 02:51:54 -0400 (EDT) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m12fzqU-0003knC; Fri, 14 Apr 100 08:44 MET DST Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: Function xxxx() does no exist In-Reply-To: <12552.955665550@sss.pgh.pa.us> from Tom Lane at "Apr 13, 2000 06:39:10 pm" To: Tom Lane Date: Fri, 14 Apr 2000 08:44:50 +0200 (CEST) CC: =?UNKNOWN-8BIT?Q?Philippe_Lef=E8vre?= , pgsql-sql@postgreSQL.org Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/155 > Philippe =?iso-8859-1?Q?Lef=E8vre?= writes: > > So I created: > > CREATE FUNCTION chk_itheme_proc(int4) RETURNS int4 > > AS 'SELECT COUNT(i_theme) FROM tbl_theme > > WHERE i_theme = $1;' > > LANGUAGE 'sql'; > > > and I created a trigger: > > CREATE TRIGGER chk_itheme_trig BEFORE INSERT OR UPDATE ON tbl_article > > FOR EACH ROW EXECUTE PROCEDURE chk_itheme_proc ('theme'); > > > but I get the message: > > ERROR: CreateTrigger: function chk_itheme_proc() does not exist > > Poorly worded error message, I'd say. You have a function > chk_itheme_proc(int4), but the trigger as you show it requires a > function with a signature of chk_itheme_proc(text) or something close > to it. Those are different functions. > > The error message ought to print out the expected parameter types to > remind you about that... No, trigger procedures in Postgres are allways defined to take no arguments and have a return type "opaque". The main error above is, that the "sql" language cannot be used to define a trigger! Use the PL/pgSQL or PL/Tcl languages instead. They're documented in the programmers manual. Version 7.0 will have PL/Perl too, but I don't know if that one can be used for trigger procs yet. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #