Re: cache lookup failed for function 72629

From: Lawrence Wong <lawrencew00(at)hotmail(dot)com>
To: <mmoncure(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: cache lookup failed for function 72629
Date: 2009-07-14 13:12:14
Message-ID: SNT101-W54F9C8C8C5CFD37ED5B304BD230@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm sorry. What does 're-applying the function source' mean? and how would I do it?

For the 'change to the table' I was talking about, I just tried to do a regular update on the table using pgAdmin III.

LW . . . Lawrence

> Date: Tue, 14 Jul 2009 09:01:38 -0400
> Subject: Re: [GENERAL] cache lookup failed for function 72629
> From: mmoncure(at)gmail(dot)com
> To: lawrencew00(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org
>
> On Tue, Jul 14, 2009 at 8:23 AM, Lawrence Wong<lawrencew00(at)hotmail(dot)com> wrote:
> > Hi,
> >
> > I had been using my database for a pretty long time now. It is postgres 8.3
> > on Windows 2003 Server. Today I tried to make a change to one of my tables
> > and I got this error message:
> >
> > 'An error has occured: ERROR: cache lookup failed for function 72629'
> >
> > I tried stopping the service and starting it. I tried restarting the
> > server. Neither worked. Has anyone seen something like this and knows a
> > solution? I would really like to avoid having to reinstall Postgres as my
> > tables are rather large and backing up and restoring would be time
> > consuming.
>
> try re-applying the function source.
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
Create a cool, new character for your Windows Live™ Messenger.
http://go.microsoft.com/?linkid=9656621

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-07-14 13:16:05 Re: cache lookup failed for function 72629
Previous Message Merlin Moncure 2009-07-14 13:12:11 Re: Flexibility of views and functions?