Hi Michael, I have several views defined in alembic migration script, and so I defined op.execute('drop view xxx') to drop all of my view sql files. When I ran script 'alembic downgrade -1' to drop all of the tables, views, indexes, MySQL, SQLITE3 worked fine. When working with Postgresql, I got below: qlalchemy.exc.InternalError: (InternalError) cannot drop table tbl_1 because other objects depend on it DETAIL: view view_1 depends on table tbl_1 HINT: Use DROP ... CASCADE to drop the dependent objects too. '\nDROP TABLE tbl_1' {}
Does sqlalchemy/alembic support 'drop table xxx cascade' for most databases? Thanks, -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/4ltVqfnAWzEJ. 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.