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
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? |