Postgresql ENUMs are entirely different from any other database so it
matters a lot. For PG, you'd want to be doing op.execute("ALTER TYPE
myenum ..."), full syntax is at
https://www.postgresql.org/docs/9.1/static/sql-altertype.html
On Mon, Sep 24, 2018 at 12:45 PM Alex Rothberg <agrothb...@gmail.com> wrote:
>
> Assuming that I am using the PEP-435 enum feature in SQLA, e.g.:
> class InvitationReason(str, enum.Enum):
> ORIGINAL_ADMIN = "ORIGINAL_ADMIN"
> FIRM_USER = "FIRM_USER"
> ...
>
> reason = db.Column(db.Enum(InvitationReason), nullable=False)
>
> and I want to add / change the values in the enum. I know that alembic won't
> auto generate the migration. Given that, what is the simplest way to specify
> the migration by hand? I am using postgres, if that matters.
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy-alembic" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy-alembic+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
