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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to