add "create_type" to sqltypes.Enum ?

[zzzeek]

this type has a "name" argument that only applies to PostgreSQL. So the type already has "backend specific" arguments, and it having a name implies directly that there's a separate CREATE statement. so we should have create_type directly present. See sqlalchemy/alembic#1347

[CaselIT]

it probably makes sense. don't we support actual enum also in another db?
Mariadb/Mysql supports them https://mariadb.com/kb/en/enum/ too, but I'm not sure if they need to be created or not

[francipvb]

Hello all,

I would like to take this issue.

I can investigate this and try to solve.

[CaselIT]

Feel free to ask question here or on gitter. Emulated types like enum are not the easiest to work with, but this issue may be easy enough!

[cobnett3]

This will be quite helpful!

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the main branch:

add create_type to Enum https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/6162

[NathanAP]

Sorry to revive this, but I guess I'm missing something. Is that proposed fix is already up?

When I try to use sqlalchemy.Enum("OK", "NICE", name="my_enum", create_type=False) I still get the same error mentioned in sqlalchemy/alembic#1347 if my enum is already created.

Using postgresql.ENUM works fine...

[zzzeek]

are you using the latest 2.1 branch from main? that's where this is