By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,702 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,702 IT Pros & Developers. It's quick & easy.

ERROR: DeleteTypeTuple: column of type tablename exists in relation #

P: n/a
I'm having a problem with a table that accidently had a column added
whose type is the same as the table. This is seriously creating a
problem as I cannot delete the table and I really don't have the
ability to destroy the database (with all the other tables) just to
get rid of this. Does anyone know of a way to get the database to
allow a drop of a table that has this sort of situation.

Here's a sample of what I get...

Any thoughts would be greatly appreciated.

db=# \d tablename
Table "tablename"
Column | Type | Modifiers
-----------+--------------------------+-----------------------------------------------------
id | integer | not null default
nextval('"tablename_seq"'::text)
name | text |
x | tablename |

db=# drop table tablename;
ERROR: DeleteTypeTuple: column of type tablename exists in relation
127493
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.