/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

2 votes204 views3 answers
Replace null in sql
SQL
0 vote203 views1 answer
Create a sql server database programmatically
SQL
0 vote195 views1 answer
Soql update query
SQL
4 votes189 views2 answers
Tsql utf to local time
SQL
23 votes203 views3 answers
Sql where contains part of string
SQL
0 vote194 views1 answer
T-SQL Retry (deadlock)
SQL
4 votes224 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote190 views2 answers
Mysql on update current_timestamp
SQL
0 vote231 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote205 views1 answer
Sql find table by name
SQL