#32869: Bug while migrating a OneToOneField to ForeignKey on PostgreSQL.
-------------------------------------+-------------------------------------
Reporter: suhailvs | Owner: nobody
Type: Bug | Status: new
Component: | Version: 3.2
Migrations | Keywords: postgres
Severity: Normal | onetoonefield foreignkey
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Using PostgreSQL Database I changed a field from `OneToOneField` to
`ForeignKey`::
{{{
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class Customer(models.Model):
user = models.OneToOneField(User, on_delete=models.CASCADE, null=True)
}}}
to
{{{
class Customer(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE, null=True)
}}}
after migrations, then i tried to create a Customer i got error:
{{{
IntegrityError at /admin/myapp/customer/add/
duplicate key value violates unique constraint
"myapp_customer_user_id_key"
DETAIL: Key (user_id)=(1) already exists.
Request Method: POST
Request URL: http://localhost:8001/admin/myapp/customer/add/
Django Version: 3.2.4
Exception Type: IntegrityError
Exception Value:
duplicate key value violates unique constraint
"myapp_customer_user_id_key"
DETAIL: Key (user_id)=(1) already exists.
Exception Location:
/home/donams/suhail/github/temp/test_unique/env/lib/python3.6/site-
packages/django/db/backends/utils.py, line 84, in _execute
Python Executable:
/home/donams/suhail/github/temp/test_unique/env/bin/python
Python Version: 3.6.9
Python Path:
['/home/donams/suhail/github/temp/test_unique',
'/usr/lib/python36.zip',
'/usr/lib/python3.6',
'/usr/lib/python3.6/lib-dynload',
'/home/donams/suhail/github/temp/test_unique/env/lib/python3.6/site-
packages']
Server time: Mon, 21 Jun 2021 11:22:55 +0000
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/32869>
Django <https://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 unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.d7cda706694e43ee727ee355bd2c21d6%40djangoproject.com.
