Re: cache lookup failed for function 72629 - Mailing list pgsql-general

From Merlin Moncure
Subject Re: cache lookup failed for function 72629
Date
Msg-id b42b73150907140601i217a1fe7p370176e3861a7f@mail.gmail.com
Whole thread Raw
In response to cache lookup failed for function 72629  (Lawrence Wong <lawrencew00@hotmail.com>)
Responses Re: cache lookup failed for function 72629
List pgsql-general
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

pgsql-general by date:

Previous
From: Lawrence Wong
Date:
Subject: cache lookup failed for function 72629
Next
From: Merlin Moncure
Date:
Subject: Re: Flexibility of views and functions?