> Jeremy Buchmann <[EMAIL PROTECTED]> 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 [[EMAIL PROTECTED]]
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
