On Thu, Jul 15, 2010 at 2:34 AM, tamanna madaan
<tamanna.madan@globallogic.com> wrote:
> Hi All
>
>
>
> I am using postgres-8.1.2 .
>
> And getting this error “cache lookup failed for function 19119”.
>
> Can anyone please let me know what could have gone wrong.
>
> How can a function go missing . And which function
>
> Its talkig about ?? its some postgres’s internal function or a user defined
> function ??
>
> How can I get function name corresponding 19119
The function is either gone (it was deleted manally from pg_proc for
example), dropped, added, etc. or there is some other problem. You
might be able to fix the problem by recreating the function
(create/replace) that is calling the function in question (your
database log should be giving you some context).
You are on 8.1.2 which is crazy. you need to immediately get the
latest bugfix release for the 8.1 series. You might want to consider
a dump/reload...read the release notes for the 8.1 series here:
http://www.postgresql.org/docs/8.1/static/release.html.
merlin