trigger trouble -- procedure not found

Поиск
Список
Период
Сортировка
От Kevin Way
Тема trigger trouble -- procedure not found
Дата
Msg-id 20010914042637.A65405@bean.overtone.org
обсуждение исходный текст
Ответы Re: trigger trouble -- procedure not found  (Bhuvan A <bhuvansql@yahoo.com>)
Re: trigger trouble -- procedure not found  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: trigger trouble -- procedure not found  (Kevin Way <kevin.way@overtone.org>)
Список 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 по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: group by weirdness
Следующее
От: Bhuvan A
Дата:
Сообщение: Re: trigger trouble -- procedure not found