From: | Michael Guerin <guerin(at)rentec(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: ESTERROR |
Date: | 2006-03-15 17:57:25 |
Message-ID: | 44185585.8080408@rentec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tom Lane wrote:
> Michael Guerin <guerin(at)rentec(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Guerin | 2006-03-15 18:02:25 | Re: ESTERROR |
Previous Message | Guido Barosio | 2006-03-15 16:43:39 | Re: ESTERROR |