On Thu, Jul 15, 2010 at 2:34 AM, tamanna madaan <tamanna.madan@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
