> Jeremy Buchmann <jeremy(at)wellsgaming(dot)com> writes:
>> Okay great, but how do I know what tables I need to drop if it just gives me
>> a number?  That 'xxxxxxx' is just some number like '8892659'.  Where is the
>> mapping from number->name?
> 
> select relname from pg_class where oid = '8892659';
> 
> More recent versions do provide the relation name instead of number
> in that error message, btw.

Okay,

cpcs=> select relname from pg_class where oid = '8892659';
relname        
---------------
pg_temp.29453.1
(1 row)

So it is one of those temp tables...now if I delete those tables with the
allow-system-table-mods switch, will that still correct the pg_inherits
table so that the dependency no longer exists?  Or can I remove that by
hand, too?

Thanks,

-- Jeremy  [jeremy(at)wellsgaming(dot)com]

In response to

• Re: Can't drop table (repost) at 2001-04-25 17:30:40 from Tom Lane

Responses

• Re: Can't drop table (repost) at 2001-04-25 18:02:12 from Tom Lane

pgsql-admin by date

Next:	From: Tom Lane	Date: 2001-04-25 18:02:12
	Subject: Re: Can't drop table (repost)
Previous:	From: Tom Lane	Date: 2001-04-25 17:30:40
	Subject: Re: Can't drop table (repost)