469,953 Members | 2,044 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,953 developers. It's quick & easy.

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

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
0 1805

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Morten Gulbrandsen | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
6 posts views Thread by Peter Frost | last post: by
669 posts views Thread by Xah Lee | last post: by
6 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.