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: cache lookup failed for function 72629 > From: mmoncure@xxxxxxxxx > To: lawrencew00@xxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > > On Tue, Jul 14, 2009 at 8:23 AM, Lawrence Wong<lawrencew00@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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 |