Re: cache lookup failed for function 72629

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Lawrence Wong <lawrencew00(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cache lookup failed for function 72629
Date: 2009-07-14 13:01:38
Message-ID: b42b73150907140601i217a1fe7p370176e3861a7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-07-14 13:12:11 Re: Flexibility of views and functions?
Previous Message Lawrence Wong 2009-07-14 12:23:23 cache lookup failed for function 72629