Re: ERROR: cache lookup failed for relation 438095645 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cache lookup failed for relation 438095645
Date
Msg-id 2913.1120707412@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: cache lookup failed for relation 438095645  (Joe Markwardt <joe@avsupport.com>)
Responses Re: ERROR: cache lookup failed for relation 438095645
List pgsql-general
Joe Markwardt <joe@avsupport.com> writes:
> On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
>> They appear to be triggers for a foreign-key constraint between
>> pl_inventory_analyzer_files_table and pl02_status_table ... so I guess
>> the question is what happened to the latter?

> I'm not sure. As far as I can tell nothing has happened to the
> pl02_status_table, nor should anything have happened to it recently.

Well, that's just plain bizarre...

The next thing to check is whether the OID mentioned in pg_trigger
(which I forgot already) is the same as the OID shown in pg_class, ie
select oid from pg_class where relname = 'pl02_status_table'.  I can
think of a few different possible pathologies here, but there's no point
speculating in advance of the data.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Adding miscadmin.h generates errors ?
Next
From: Tom Lane
Date:
Subject: Re: About unsigned smallint?