(Mike: my problem is solved, but please read my final sentence for an enhancement request)
>>> I'm guessing the old User_Roles type still exists in the database. You can >>> drop it with "DROP TYPE User_Roles". Yes, this is what I figured was happening, I wasn't sure how to get rid of it though >>> pgAdmin does not show types by default. You can enable it by going to File >>> > Options, Browser tab, and checking the "Types" checkbox. Ahhh, *this* is what I needed to know >>> Since PostgreSQL types are not owned by tables, I don't think there is a >>> good way to make this automatic. You can try adding an "after-drop" DDL >>> event that drops the User_Roles type when you drop the table, but that has >>> its own problems. Yeah, for reuse reasons, I can see that it makes sense that tables don't own types, and that dropping the table doesn't drop the type. Mike, may I suggest this as an enhancement: If SQLA is creating a table with an Enum column, and if there's already an Enum with the specified name, it should spit out an error if the list of values for the existing and requested Enums don't match? ------------------------------------------------------------------------- DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. ------------------------------------------------------------------------- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
