pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcache lookup failed
2+ messages / 2 participants
[nested] [flat]
* cache lookup failed
@ 2008-08-19 18:01 c k <shreeseva.learning@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: c k @ 2008-08-19 18:01 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin
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.
Thanks and Regards,
CPK
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] cache lookup failed
@ 2008-08-20 07:12 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: c k <shreeseva.learning@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Albe Laurenz @ 2008-08-20 07:12 UTC (permalink / raw)
To: c k *EXTERN* <shreeseva.learning@gmail.com>; pgsql-general@postgresql.org; pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-20 07:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-19 18:01 cache lookup failed c k <shreeseva.learning@gmail.com>
2008-08-20 07:12 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox