Problem creating trigger
От | Michael Rowan |
---|---|
Тема | Problem creating trigger |
Дата | |
Msg-id | 4996D5AE-B6B7-458B-980B-1645AEC4C591@internode.on.net обсуждение исходный текст |
Ответы |
Re: Problem creating trigger
|
Список | pgsql-novice |
Using PostgreSQL 9.1 I have created my first function. Heres the create statement reported by pgAdminIII: CREATE OR REPLACE FUNCTION detect_branch(integer) RETURNS integer AS ' UPDATE company SET co_has_branch_sa=CASE WHEN (SELECT sum(br_ca_rate_sa) FROM branch WHERE br_co_id=$1)>0 THEN TRUE ELSEFALSE END WHERE co_id=$1 RETURNING 1; ' LANGUAGE sql VOLATILE COST 100; ALTER FUNCTION detect_branch(integer) OWNER TO postgres; Works well. However, if I try to create a trigger: CREATE TRIGGER run_detect_branch AFTER UPDATE OR INSERT ON branch FOR EACH ROW EXECUTE PROCEDURE detect_branch() I get an error "function detect_branch() does not exist". Can some kind soul tell me why? Michael Rowan mike.rowan@internode.on.net 11 Kingscote Street ALBERTON South Australia 5014 tel 618 8240 3993 mob 0417 812 509
В списке pgsql-novice по дате отправления: