我使用Django 1.2和1.3以及MySql后端。
偶尔在使用South迁移我的MySql数据库时会收到错误消息:
! Error found during real run of migration! Aborting.
! Since you have a database that does not support running
! schema-altering statements in transactions, we have had
! to leave it in an interim state between migrations.
...
! The South developers regret this has happened, and would
! like to gently persuade you to consider a slightly
! easier-to-deal-with DBMS
我在想是否将我的数据库从MySQL迁移到PostgreSQL可以避免这个错误。其次,从MySQL迁移到PostgreSQL是否比在MySQL数据库上执行dumpdata,更改设置以指向PostgreSQL并在新后端上执行loaddata要复杂?我看过这个stackoverflow问题,但它提到了他的数据库太大的问题。我不认为我的数据库会有这个问题。我的Django项目中没有任何自定义SQL命令。