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/
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! |