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. 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 |
- Re: [SQL] trigger error Yudie
- Re: [SQL] trigger error Dmitry Tkach
- Re: [SQL] trigger error Mendola Gaetano