Re: ESTERROR - Mailing list pgsql-novice

From Michael Guerin
Subject Re: ESTERROR
Date
Msg-id 44185585.8080408@rentec.com
Whole thread Raw
In response to Re: ESTERROR  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ESTERROR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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
>


pgsql-novice by date:

Previous
From: "Guido Barosio"
Date:
Subject: Re: ESTERROR
Next
From: Michael Guerin
Date:
Subject: Re: ESTERROR