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 worth it. A migration library that I started up some months ago, but haven't had time to work on, is called Alembic, will also eventnually have this. I will be needing ALTER support and a way of rewriting enums (also the CHECK constraint used in non-ENUM platforms) for my current gig in the coming months so I should be picking up work on Alembic soon (it has no docs yet but its at https://bitbucket.org/zzzeek/alembic - at the very least it has examples on how things like this are done. On Mar 25, 2011, at 7:15 PM, Mahmoud Abdelkader wrote: > 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? > > Thanks in advance, > Mahmoud > > -- > 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. -- 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.