Re: cache lookup failed - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: cache lookup failed
Date
Msg-id Pine.LNX.4.30.0109121659080.694-100000@peter.localdomain
Whole thread Raw
In response to cache lookup failed  (victor <victor@work.ro>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: victor
Date:
Subject: cache lookup failed
Next
From: Haller Christoph
Date:
Subject: ERROR: Cannot insert a duplicate key into a unique index