#13248: manage.py sqlsequencereset misses m2m tables
------------------------------------------+---------------------------------
Reporter: EroSennin | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version: SVN
Keywords: | Stage: Unreviewed
Has_patch: 0 |
------------------------------------------+---------------------------------
Sequence reset code not generated for tables that are implicitly created
for m2m fields.
Example models:
{{{
#!python
class User(models.Model):
pass
class Group(models.Model):
users = models.ManyToManyField(User)
}}}
The correct result of `./manage.py sqlsequencereset` should be:
{{{
#!sql
BEGIN;
SELECT setval('"example_user_id_seq"', coalesce(max("id"), 1), max("id")
IS NOT null) FROM "example_user";
SELECT setval('"example_group_id_seq"', coalesce(max("id"), 1), max("id")
IS NOT null) FROM "example_group";
SELECT setval('"example_group_users_id_seq"', coalesce(max("id"), 1),
max("id") IS NOT null) FROM "example_group_users";
COMMIT;
}}}
Actual (incorrect) result:
{{{
#!sql
BEGIN;
SELECT setval('"example_user_id_seq"', coalesce(max("id"), 1), max("id")
IS NOT null) FROM "example_user";
SELECT setval('"example_group_id_seq"', coalesce(max("id"), 1), max("id")
IS NOT null) FROM "example_group";
COMMIT;
}}}
Sequence `example_group_users_id_seq` is ignored here.
--
Ticket URL: <http://code.djangoproject.com/ticket/13248>
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 django-upda...@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
