X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 14E9330DBC6 for ; Tue, 10 Jun 2003 15:49:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 99693-09 for ; Tue, 10 Jun 2003 12:49:37 -0300 (ADT) Received: from axiontech.com (unknown [216.52.172.74]) by svr1.postgresql.org (Postfix) with SMTP id A975D30DD5A for ; Tue, 10 Jun 2003 12:49:36 -0300 (ADT) Received: (qmail 18538 invoked from network); 10 Jun 2003 15:49:35 -0000 Received: from unknown (HELO yudie) (192.168.1.132) by mail.axiontech.com (192.168.1.6) with SMTP; 10 Jun 2003 15:49:35 -0000 Message-ID: <001b01c32f69$eda57120$8401a8c0@yudie> From: "Yudie" To: Subject: trigger error Date: Tue, 10 Jun 2003 11:04:05 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C32F40.01C3FDE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Archive-Number: 200306/83 X-Sequence-Number: 13841 This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C32F40.01C3FDE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I',m trying to create trigger with plpgsql trigger function then I got this error message when trigger executed: Number: -2147467259 Error while executing th query; ERROR: fmgr_info: function 1546856080: cache lookup failed Here is the function code: CREATE FUNCTION TRIGGER_UPDATE_AXPRDT_STATUS() RETURNS OPAQUE AS 'BEGIN IF NEW.ONHAND =3D 0 THEN NEW.STATUS =3D ''D''; END IF; RETURN NEW; END;' LANGUAGE 'plpgsql'; CREATE TRIGGER TRIGGER_AXPRDT_FUTURESTATUS BEFORE UPDATE ON AXPRDT FOR EACH ROW EXECUTE PROCEDURE TRIGGER_UPDATE_AXPRDT_STATUS(); Please Help..=20 Yudie ------=_NextPart_000_0018_01C32F40.01C3FDE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I',m trying to create trigger with plpgsql= trigger=20 function

then I got this error message when tr= igger=20 executed:

Number: -2147467259

Error while executing th query;

ERROR: fmgr_info: function 1546856080: cac= he lookup=20 failed

Here is the function code:

CREATE FUNCTION=20 TRIGGER_UPDATE_AXPRDT_STATUS()
RETURNS OPAQUE
AS 'BEGIN
IF= =20 NEW.ONHAND =3D 0 THEN
NEW.STATUS =3D ''D'';
= =20 END IF;
RETURN NEW;
END;'
LANGUAGE 'plpgsql';

CREATE TRIGGER=20 TRIGGER_AXPRDT_FUTURESTATUS
BEFORE UPDATE ON AXPRDT
FOR EACH=20 ROW
EXECUTE PROCEDURE TRIGGER_UPDATE_AXPRDT_STATUS();

Please Help..

Yudie

------=_NextPart_000_0018_01C32F40.01C3FDE0--