Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] cache lookup failed

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "c k *EXTERN*" <shreeseva(dot)learning(at)gmail(dot)com>,<pgsql-general(at)postgresql(dot)org>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] cache lookup failed
Date: 2008-08-20 07:12:58
Message-ID: D960CB61B694CF459DCFB4B0128514C20267A3FE@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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

In response to

pgsql-admin by date

Next:From: Thomas JacobDate: 2008-08-20 10:20:57
Subject: PgWiki entry Shared DB Hosting (was Re: Best practicerunning a shared DB hosting server)
Previous:From: Shashwat_NigamDate: 2008-08-20 06:41:44
Subject: Regarding access to a user

pgsql-general by date

Next:From: Tom TomDate: 2008-08-20 08:14:19
Subject: Re: Re: pg_restore fails on Windows
Previous:From: Roshni ManiDate: 2008-08-20 06:47:01
Subject: FW: syntax for Copy command via libpqxx

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group