Received: from femail41.sdc1.sfba.home.com (femail41.sdc1.sfba.home.com [24.254.60.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8E4Qm758392 for ; Fri, 14 Sep 2001 00:26:49 -0400 (EDT) (envelope-from kway@overtone.org) Received: from bean.overtone.org ([24.249.254.100]) by femail41.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20010914042641.ZMMV25759.femail41.sdc1.sfba.home.com@bean.overtone.org> for ; Thu, 13 Sep 2001 21:26:41 -0700 Received: by bean.overtone.org (Postfix, from userid 1001) id BA5F55B618; Fri, 14 Sep 2001 04:26:38 +0000 (GMT) Date: Fri, 14 Sep 2001 04:26:37 +0000 From: Kevin Way To: pgsql-sql@postgresql.org Subject: trigger trouble -- procedure not found Message-ID: <20010914042637.A65405@bean.overtone.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200109/69 X-Sequence-Number: 4715 I'm having trouble creating a trigger. First i'm creating a function, add_to_search in PL/pgSQL. \df verifies the existance of this function: smallint | add_to_search | text, text, text, integer but when I call: CREATE TRIGGER item_insert_search_add AFTER INSERT ON item FOR EACH ROW EXECUTE PROCEDURE add_to_search (name, description, reason, node_id); I get: ERROR: CreateTrigger: function add_to_search() does not exist What am I missing here? It seems to me that I'm missing something very simple, but I can't figure out what it is for the life of me. Kevin Way