One of my tables used to have something like: role = Column(Enum('user', 'admin', name = User_Roles))
Now I want to change it to: role = Column(Enum('user', 'superuser', name = User_Roles)) But I can't figure out how to change the enum values in the database. I've tried dropping the table from pgAdmin and recreating it with SQLAlchemy, which all seems to go fine, but then when I go back to pgAdmin and try to enter a new user with the role 'superuser', I get an error back: An error has occurred: ERROR: invalid input value for enum "User_Roles": "superuser" LINE 1: ..., password, role) VALUES ('john'::text, 'pass'::text, 'superuser... ^ I've tried searching through pg_admin for where this enum is being defined, but I can't find it. Can anyone tell me where in pgAdmin I need to go to change or delete the enum, or how to make SQLAlchemy do so when it creates the table? Cheers, Cam Cameron Jackson Engineering Intern Air Operations Thales Australia Thales Australia Centre, WTC Northbank Wharf, Concourse Level, Siddeley Street, Melbourne, VIC 3005, Australia Tel: +61 3 8630 4591 cameron.jack...@thalesgroup.com.au<mailto:cameron.jack...@thalesgroup.com.au> | www.thalesgroup.com.au<http://www.thalesgroup.com.au> ------------------------------------------------------------------------- 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 sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.