Trigger Problem

From: Mohammad Faisal <faisalchouhan(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Trigger Problem
Date: 2001-09-20 07:58:46
Message-ID: 20010920075846.84208.qmail@web10602.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-sql by date

  From Date Subject
Next Message rdear 2001-09-20 09:45:30 Re: PL/PGSQL Regexe
Previous Message Tom Lane 2001-09-20 06:55:54 Re: Out of free buffers... HELP!