Re: [ADMIN] Can't drop table (repost)

[Tom Lane]

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.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html