From: | Jeremy Buchmann <jeremy(at)wellsgaming(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Can't drop table |
Date: | 2001-04-21 22:21:19 |
Message-ID: | B70755EF.295F%jeremy@wellsgaming.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I have a weird situation here...I'm trying to drop a table, but it tells me
that "Relation 'xxxxxxx' inherits 'mytable'". So I renamed mytable to
myoldtable and created a new mytable. Now, the new mytable is missing the
fields I was trying to add, and when I try to drop it, it says "Relation
'xxxxxxx' inherits 'mytable'". And when I try to drop myoldtable, it says
"Relation 'xxxxxxx' inherits 'myoldtable'". How do I get out of this mess?
Also, I noticed some tables named like pg_temp.1970.0 and such. They seem
to contain some junk data from queries or something, but it won't let me
delete them...how can I get rid of them?
I'm using pgsql 6.5.3 on Linux 2.2
Thanks,
-- Jeremy [jeremy(at)wellsgaming(dot)com]
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Naujock | 2001-04-22 00:43:36 | Database security at the database level. |
Previous Message | Dan Browning | 2001-04-21 01:18:48 | Re: Bugs in PostgreSQL v7.1 rpms for RedHat |