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: mmonc...@gmail.com > To: lawrence...@hotmail.com > CC: pgsql-general@postgresql.org > > On Tue, Jul 14, 2009 at 8:23 AM, Lawrence Wong<lawrence...@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. http://go.microsoft.com/?linkid=9656621