[sqlalchemy] Altering to add an enum to an existing Enum Column type

Hello everyone:) I have a table with a enum column containing statuses: STARTED, RESERVED, FINISHED. I want to add a status WAITING to this enum using SQLAlchemy without dropping down into SQL. I'm using PostgreSQL 8.4.6 I don't think there's a way to do it without dropping into SQL. Any ideas?

Re: [sqlalchemy] Altering to add an enum to an existing Enum Column type

you can build yourself an Alter construct and use that. You can build new constructs using http://www.sqlalchemy.org/docs/core/compiler.html .The construct will then work against different backends transparently for each one you build. If you're only on PG then the effort is not entirely

Re: [sqlalchemy] Altering to add an enum to an existing Enum Column type

Thanks Michael! I'll check it out. Appreciate it. On Fri, Mar 25, 2011 at 4:36 PM, Michael Bayer mike...@zzzcomputing.comwrote: you can build yourself an Alter construct and use that. You can build new constructs using http://www.sqlalchemy.org/docs/core/compiler.html .The construct