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.
In response to
pgsql-novice by date
|Next:||From: ben.carlyle||Date: 2002-06-11 23:35:08|
|Subject: Postgresql Historical data store|
|Previous:||From: Josh Berkus||Date: 2002-06-11 20:56:27|
|Subject: Re: inserting a null value into table|