cache lookup failed

c k wrote:

I got following error while testing some newly created functions.

ERROR: cache lookup failed for function 111462
CONTEXT: PL/pgSQL function "uf_postdoc" line 25 at FOR over
SELECT rows

********** Error **********

ERROR: cache lookup failed for function 111462
SQL state: XX000
Context: PL/pgSQL function "uf_postdoc" line 25 at FOR over
SELECT rows

what this means? and how to solve it?
I searched manual but not got much help.

Look there:
http://www.postgresql.org/docs/current/static/plpgsql-statements.html

Keywords: plan, cache

You probably dropped the function and created a new function with the same name.

Disconnect and reconnect, and everything should work.

Yours,
Laurenz Albe