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(at)gmx(dot)net http://funkturm.homeip.net/~peter