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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
