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: B70C5BD6.2A16%jeremy@wellsgaming.com (view raw or flat)
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.

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]


In response to

Responses

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-2014 The PostgreSQL Global Development Group