trigger trouble -- procedure not found

From: Kevin Way <kevin(dot)way(at)overtone(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: trigger trouble -- procedure not found
Date: 2001-09-14 04:26:37
Message-ID: 20010914042637.A65405@bean.overtone.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bhuvan A 2001-09-14 04:59:57 Re: trigger trouble -- procedure not found
Previous Message Joseph Shraibman 2001-09-13 21:53:42 Re: group by weirdness