From: | Jon Erickson <jon(dot)erickson(at)neicoltech(dot)org> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Changed function |
Date: | 2002-06-11 21:52:46 |
Message-ID: | 1023832396.1742.107.camel@xit.neicoltech.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | ben.carlyle | 2002-06-11 23:35:08 | Postgresql Historical data store |
Previous Message | Josh Berkus | 2002-06-11 20:56:27 | Re: inserting a null value into table |