|
This is more of a heads up than a question. The migrations in OSQA appear to be missing the create_unique statements required to support unique_together constraints. For example, migration 0042_auto__add_userproperty creates the forum_userproperty table but does not create the unique_together constraint. According to the South developers, this means that the version of South used to generate the migration scripts is most likely buggy. See: http://groups.google.com/group/south-users/browse_thread/thread/fe92703d787e870f |
|
That should be probably the cause. And since that one is a recent migration, we'll probably create one optional migration to ensure that the constraints are created. This detail only affects database performance, although very residual since both postgres and mysql should be able to optimize the queries, even though there is no compound unique constraint, since unless there is some catastrophe the code should not produce duplicate entries. Thanks for noticing it. |
