Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8KBFZe06147 for ; Thu, 20 Sep 2001 07:15:35 -0400 (EDT) (envelope-from andreak@officenet.no) Received: from www.nettverk.no (pc250.ko.kommorg.no [193.212.171.250] (may be forged)) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8KB0SD99099 for ; Thu, 20 Sep 2001 07:00:28 -0400 (EDT) (envelope-from andreak@officenet.no) Received: from localhost.localdomain ([127.0.0.1] helo=officenet.no) by www.nettverk.no with smtp (Exim 3.12 #1) id 15k1VR-0004v1-00 for pgsql-sql@postgresql.org; Thu, 20 Sep 2001 12:56:33 +0200 Date: Thu, 20 Sep 2001 10:56:33 -0000 To: pgsql-sql@postgresql.org Subject: Re: Trigger Problem From: Andreas Joseph Krogh X-Mailer: TWIG 2.3.2 Message-Id: X-Archive-Number: 200109/169 X-Sequence-Number: 4849 Mohammad Faisal 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 to create the plpgsql language on your database. -- Andreas Joseph Krogh