Skip site navigation (1) Skip section navigation (2)

Re: Can't drop table (repost)

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can't drop table (repost)
Date: 2001-04-25 17:47:51
Message-ID: (view raw or whole 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.


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

So it is one of those temp 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?


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

In response to


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group