Re: ERROR: cache lookup failed for relation 438095645
От | Joe Markwardt |
---|---|
Тема | Re: ERROR: cache lookup failed for relation 438095645 |
Дата | |
Msg-id | 1120680082.27667.44.camel@Odin обсуждение исходный текст |
Ответ на | Re: ERROR: cache lookup failed for relation 438095645 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: ERROR: cache lookup failed for relation 438095645
|
Список | pgsql-general |
On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote: > Joe Markwardt <joe@avsupport.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@postgresql.org so that your > message can get through to the mailing list cleanly >
Вложения
В списке pgsql-general по дате отправления: