Re: Can't drop table (repost)

> 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]