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
Re: trigger trouble -- procedure not found Re: trigger trouble -- procedure not found |
Список | 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 по дате отправления: