trigger trouble -- procedure not found - Mailing list pgsql-sql

From Kevin Way
Subject trigger trouble -- procedure not found
Date
Msg-id 20010914042637.A65405@bean.overtone.org
Whole thread Raw
Responses Re: trigger trouble -- procedure not found
Re: trigger trouble -- procedure not found
Re: trigger trouble -- procedure not found
List 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


pgsql-sql by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: group by weirdness
Next
From: Bhuvan A
Date:
Subject: Re: trigger trouble -- procedure not found