Skip site navigation (1) Skip section navigation (2)

Re: Changed function

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: ben.carlyleDate: 2002-06-11 23:35:08
Subject: Postgresql Historical data store
Previous:From: Josh BerkusDate: 2002-06-11 20:56:27
Subject: Re: inserting a null value into table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group