时间戳

首页 > 解决方案 > 使用 postgresdb 删除列时，Flask-migrate 无法升级

python - 使用 postgresdb 删除列时，Flask-migrate 无法升级

问题描述

我正在使用烧瓶和 Postgres DB，当我进行数据库升级时，我从烧瓶代码中的模型中删除了一些列，出现此错误 -

INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 9a57968ad4f7, remove some columns
Traceback (most recent call last):
  File "/home/veerendhar/PycharmProjects/erp-be/venv/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/home/veerendhar/PycharmProjects/erp-be/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.DependentObjectsStillExist: cannot drop table session because other objects depend on it
DETAIL:  constraint session_message_sessionId_fkey on table session_message depends on table session
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

我该如何解决它...？

标签： pythonpostgresqlflasksqlalchemyflask-sqlalchemy

解决方案

推荐阅读