"Yudie" <[EMAIL PROTECTED]> wrote:
> 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
You must have dropped and recreated the function after your trigger was
created...
You need to recreate the trigger now, so that it picks up the new
function id.
In the future use 'CREATE OR REPLACE' to modify a function instead of
DROP and CREATE - this will make sure the modified function keep
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_
