Обсуждение: cache lookup failed

Hi,
I have this function:

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

please tell me what it's rong.

Suppose you create a function function1 and a trigger
that calls function1. Then you drop function1 and
re-create function1.  Now you will find that the
trigger can't see function1's existence. trigger (and
other object too) refeerences functions using OID,
not the function name.

I also feel it being inconvient for postgresql to use
OID's instead of object names.

CN

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com