Re: Changed function

On Mon, 2002-06-03 at 09:31, Reinhard Hnat wrote:
> 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.

You can delete and re-create the trigger that references your function.
This is the only way that I know how to fix the problem you described.

Jon