Trigger Problem
От | Mohammad Faisal |
---|---|
Тема | Trigger Problem |
Дата | |
Msg-id | 20010920075846.84208.qmail@web10602.mail.yahoo.com обсуждение исходный текст |
Список | pgsql-sql |
hey all I have created a function that is used in a trigger. -------------------------------------------------- -------------------------------------------------- CREATE TRIGGER tr_insert_on_a AFTER INSERT OR UPDATE ON A FOR EACH ROW EXECUTE PROCEDURE fn_insert_on_a(); -------------------------------------------------- -------------------------------------------------- CREATE function fn_insert_on_a() RETURNS OPAQUE AS' BEGIN INSERT INTO B name, a_ref VALUES (NEW.name,NEW.id); RETURN NEW; END; ' LANGUAGE 'plpgsql'; I am getting following error. ERROR : Unrecognized language specified in a CREATE FUNCTION: plpgsql. Recognized languages are sql,c,internal and the created procedure languages. NOTE: I have studied in documenatation that only plpgsql functions are written to be used in triggers. any help in this regard. thanks in advance. Faisal __________________________________________________ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
В списке pgsql-sql по дате отправления: