On Thu, Jul 15, 2010 at 10:21:52AM -0400, Merlin Moncure wrote: > 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. You might also want to note that 8.1's end of life is in November, so start planning the upgrade to 9.0 right now. You will likely need to clean up some client code in order for that to work, as modern versions of PostgreSQL don't allow some of the sloppy and dangerous things (casting automatically to and from text, e.g.) that former versions did. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
