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   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to