trigger error - Mailing list pgsql-sql

From Yudie
Subject trigger error
Date
Msg-id 001b01c32f69$eda57120$8401a8c0@yudie
Whole thread Raw
Responses Re: trigger error
List pgsql-sql
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 = 0  THEN
    NEW.STATUS = ''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..
 
Yudie

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: "Join" on delimeter aggregate query
Next
From: Dmitry Tkach
Date:
Subject: Re: trigger error