I have changed a plpgsql function using phpPgAdmin II. When the related
trigger was fired next time i saw the following message:
PostgreSQL said: ERROR: fmgr_info: function 542564: cache lookup failed
the problem seems to be, that the oid of the function has changed. obviously
the trigger remembered the old oid and does not search for the new oid of
the function which name is referenced in the trigger definition. what is to
do to make the changed function useable again? how can the trigger learn to
reference the right function.
Best regards
Reinhard Hnat
hnat@logotronic.co.at