| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Jacob | 2008-08-20 10:20:57 | PgWiki entry Shared DB Hosting (was Re: Best practice running a shared DB hosting server) |
| Previous Message | Shashwat_Nigam | 2008-08-20 06:41:44 | Regarding access to a user |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Tom | 2008-08-20 08:14:19 | Re: Re: pg_restore fails on Windows |
| Previous Message | Roshni Mani | 2008-08-20 06:47:01 | FW: syntax for Copy command via libpqxx |