Re: Can't drop table (repost)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can't drop table (repost)
Date: 2001-04-25 17:30:40
Message-ID: 29752.988219840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeremy Buchmann 2001-04-25 17:47:51 Re: Can't drop table (repost)
Previous Message Jeremy Buchmann 2001-04-25 17:16:37 Re: Can't drop table (repost)