Re: [SQL] cache lookup failed

2001-09-12 Thread Peter Eisentraut
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

[SQL] cache lookup failed

2001-09-12 Thread victor
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.

[SQL] cache lookup failed ???? What is it ???!!!

2001-06-22 Thread J.Fernando Moyano
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I can't execute this SQL query: DELETE FROM piezas WHERE ord_mec = '01-001' I get: ERROR: fmgr_info: function 39816: cache lookup failed Can someone help me with this error ?? ** CREATE TABLE