alter table with sequence

[Ofir Herzas]

rename_table operation does not rename sequences if they exist.

This causes a problem that the renamed table is unusable since the sequence is missing.

In Oracle, a simple rename works well (RENAME old_seq_name TO new_seq_name;) although it says "table renamed".

Is there a sequence rename operation in Alembic? (not "drop" and "create")

[Mike Bayer]

built-in operations for sequences are a TODO for now, you can emit the ALTER statement directly using op.execute():

op.execute("ALTER SEQUENCE foo RENAME TO bar")

--
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-alem...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ofir Herzas]

Thanks Mike. I already did use execute.
I was hoping for a more generic solution, but it'll do for now...

You received this message because you are subscribed to a topic in the Google Groups "sqlalchemy-alembic" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlalchemy-alembic/MYyM1j-cWm4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sqlalchemy-alem...@googlegroups.com.