Thanks Michael! I'll check it out. Appreciate it.

On Fri, Mar 25, 2011 at 4:36 PM, Michael Bayer <mike...@zzzcomputing.com>wrote:

> 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.
>
>

-- 
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.

Reply via email to