From: | Joe Markwardt <joe(at)avsupport(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: cache lookup failed for relation 438095645 |
Date: | 2005-07-06 20:01:22 |
Message-ID: | 1120680082.27667.44.camel@Odin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
> Joe Markwardt <joe(at)avsupport(dot)com> writes:
> >>> I am getting this error "ERROR: cache lookup failed for relation
> >>> 438095645" when i try to run "drop table
> >>> pl_inventory_analyzer_files_table ;" from psql on the database server.
> >>
> >> Look through the system catalogs to see where that OID appears.
>
> > I found the attached entries in the pg_trigger table, but I'm not quite
> > sure how to read them, or what to do about them.
>
> 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.
Its just a lookup table relating status ID's to descriptive names, and
it only has about 8 records in it, and the last change was several
months ago. I've attached the \d output of both tables, and everything
appears kosher to me. Is there something in particular I should look
for?
Thanks
Joe
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
Attachment | Content-Type | Size |
---|---|---|
psql_table_schema.txt | text/plain | 1.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Hayward | 2005-07-06 20:19:18 | Re: current_user inside SECURITY DEFINER function? |
Previous Message | Peter Eisentraut | 2005-07-06 19:56:11 | Re: current_user inside SECURITY DEFINER function? |