Mohammad Faisal <[EMAIL PROTECTED]> said: > 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.
You need to issue: $ createlang plpgsql <db_name> to create the plpgsql language on your database. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
