#4192: manage.py sqlindexes does not create the index for unique_together fields
--------------------------------------+-------------------------------------
Reporter: litnimax | Owner: nobody
Status: new | Milestone:
Component: django-admin.py | Version: SVN
Resolution: | Keywords:
Stage: Accepted | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
--------------------------------------+-------------------------------------
Comment (by rjalves):
If your backend is MySQL (I don't about other backends), UNIQUE and
PRIMARY KEY columns are automatically (internally) indexed.
You don't need to explicitly add other indexes to the same columns.
Also from a construction point of view, UNIQUE is not a standard INDEX as
it will fail if the column in question has non unique content. Therefore
from my point of view, it should be part of the CREATE TABLE and not of
CREATE INDEX statements.
In summary, the original decision is supported by the same reasons that
made syncdb not to issue ALTER TABLE statements.
--
Ticket URL: <http://code.djangoproject.com/ticket/4192#comment:3>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
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/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
