Thread: cache lookup failed

cache lookup failed

From
victor
Date:
Hi,
I have this function:

CREATE FUNCTION add_one (integer) RETURNS integer AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';

from postgres doc.
When I try somethin like this: 

SELECT add_one(4);

I get :

ERROR:  fmgr_info: function 20086: cache lookup failed

please tell me what it's rong. 


Re: cache lookup failed

From
Peter Eisentraut
Date:
victor writes:

> CREATE FUNCTION add_one (integer) RETURNS integer AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'plpgsql';
>
> >from postgres doc.
> When I try somethin like this:
>
> SELECT add_one(4);
>
> I get :
>
> ERROR:  fmgr_info: function 20086: cache lookup failed

Possibly you have dropped and recreated the plpgsql language handler after
the function was already created.  If so, recreate the function.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter