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
Import Notes
Resolved by subject fallback