Re: ESTERROR

Поиск
Список
Период
Сортировка
От Michael Guerin
Тема Re: ESTERROR
Дата
Msg-id 44185585.8080408@rentec.com
обсуждение исходный текст
Ответ на Re: ESTERROR  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ESTERROR
Список 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 по дате отправления:

Предыдущее
От: "Guido Barosio"
Дата:
Сообщение: Re: ESTERROR
Следующее
От: Michael Guerin
Дата:
Сообщение: Re: ESTERROR