Re: ESTERROR

Tom Lane wrote:
> Michael Guerin <guerin@rentec.com> writes:
>
>> Looks like my problem is back again today:
>> ERROR:  relation with OID 76511 does not exist
>> What's the best way to track down this issue?
>>
>
> Is it always the same OID mentioned in the errors, or are they variable?
>
It was the same OID, until I restarted then it changed to a new OID.
I've since restarted and haven't seen the error, but I suspect I'll see
it again later today.

> If always the same, my first thought would be a corrupt entry in the
> system catalogs --- try looking for occurrences of that value in the
> catalog columns that link to pg_class.oid, such as pg_index.indexrelid.
> The system catalogs documentation for your PG version will show you
> which columns to look at exactly --- see
> http://www.postgresql.org/docs/8.1/static/catalogs.html
> (adjust in the obvious way for your version)
>
will do.
>             regards, tom lane
>