/SQL/Duplicate key value violates unique constraint "django_admin_log_pkey"

Duplicate key value violates unique constraint "django_admin_log_pkey"

-- Enter the DB shell with `./manage.py dbshell`

-- Get latest ID
SELECT id FROM "django_admin_log" ORDER BY id DESC LIMIT 1;

-- Set the next value of the ID sequence to the result of the first query + 1
SELECT setval('django_admin_log_id_seq', LASTID + 1);

-- (replace `LASTID` with the result of the first query)

Source: stackoverflow.com

Duplicate key value violates unique constraint "django_migrations_pkey"

from django.db import connections

query = "SELECT setval('django_migrations_id_seq', (SELECT MAX(id) FROM django_migrations))"
cursor = connections['default'].cursor()
cursor.execute(query) 
row = cursor.fetchone()

Source: stackoverflow.com

Similar codes

1 vote222 views3 answers
How to pass password to mysql command line
SQL
1 vote196 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote202 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote219 views1 answer
Postgres install unaccent extension
SQL
19 votes195 views4 answers
Rename database in sql
SQL
-1 vote192 views2 answers
Postgres autoincrement primary key
SQL
1 vote210 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote232 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote198 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote204 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL