help me, please
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?
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