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@gmail.com
> To: lawrencew00@hotmail.com
> CC: pgsql-general@postgresql.org
>
> On Tue, Jul 14, 2009 at 8:23 AM, Lawrence Wong<lawrencew00@hotmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Create a cool, new character for your Windows Live™ Messenger.
Check it out