Re: Postgresql Sequence update on data migration

2022-05-25 Thread 'Adam Johnson' via Django developers (Contributions to Django itself)
Hi! I think you've found the wrong mailing list for this post. This mailing list is for discussing the development of Django itself, not for support using Django. This means the discussions of bugs and features in Django itself, rather than in your code using it. People on this list are unlikely

Re: Postgresql Sequence update on data migration

2022-05-25 Thread mohammad ali mehdizadeh
Matthew thank you for your attention I mean we have a scenario that can make errors. We have a sequence for a primary key, if we insert some objects with predefined `id` and then we let the sequence create a key for us, then we will have a duplicate primary key error. Do you mind django want to

RE: Postgresql Sequence update on data migration

2022-05-25 Thread Matthew Pava
Please see: https://docs.djangoproject.com/en/dev/ref/django-admin/#sqlsequencereset Also, this question is more for the Django Users mailing list than the Django Developers mailing list. From: django-developers@googlegroups.com On Behalf Of mohamad ali mehdizadeh Sent: Wednesday, May 25,

Postgresql Sequence update on data migration

2022-05-25 Thread mohamad ali mehdizadeh
I have a migration from an old table to a new table, so when I migrate also data of old table, I try to keep PrimaryKey values the same as old table. so every thing go well until I see primary key duplicate value errors from Postgresql, I check it and so the Sequence of the new table was not