Thread

1. help me, please

   Vinicio Llumiquinga <vinill@alainet.org> — 2001-05-09T19:02:26Z

   I have a problem
   I have a function in plpgsql:
   
   create function add_one (integer) returns integer as '
   begin
       return $1+1;
   end;
   ' language 'plpgsql';
   
   When I create in psql monitor this function the message is CREATED
   Then I write:
   select add_one(1);
   and always say:
   
   fmgr_info: function 18816: cache lookup failed
   
   This happend when I write any function.
   How Can I resolve this problem?
   
   
   
   

2. Re: help me, please

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-11T14:16:21Z

   Vinicio Llumiquinga <vinill@alainet.org> writes:
   > fmgr_info: function 18816: cache lookup failed
   > This happend when I write any function.
   
   I suspect you dropped the plpgsql call handler function.
   
   If so, the only convenient recovery method AFAIK is to drop the
   plpgsql language entry and all your plpgsql functions (dump them
   out first!) then rerun "createlang" and reload your functions.
   
   			regards, tom lane