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 17:30:12 |
Message-ID: | 1120671012.27667.29.camel@Odin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2005-07-06 at 11:20 -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.
> pg_index.indexrelid, pg_trigger.tgconstrrelid, pg_depend.objid,
> pg_depend.refobjid are likely places.
>
> regards, tom lane
>
Tom,
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.
Thanks
Joe
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
Attachment | Content-Type | Size |
---|---|---|
pg_trigger_output.txt | text/plain | 2.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ben-Nes Yonatan | 2005-07-06 17:52:39 | Re: Pl/PgsSQL array |
Previous Message | Richard Huxton | 2005-07-06 15:20:46 | Re: Pl/PgsSQL array |