From: Kevin Way <kevin.way@overtone.org>
To: pgsql-sql@postgresql.org
Subject: trigger trouble -- procedure not found
Date: Fri, 14 Sep 2001 04:26:37 +0000
Message-ID: <20010914042637.A65405@bean.overtone.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kevin.way@overtone.org
Subject: Re: trigger trouble -- procedure not found
In-Reply-To: <20010914042637.A65405@bean.overtone.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox