/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

0 vote238 views1 answer
Sql: extract day text from datetime value
SQL
0 vote281 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote214 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
16 votes220 views4 answers
Sort by sql
SQL
0 vote227 views1 answer
Is not sql
SQL
0 vote213 views1 answer
Sql character index
SQL
0 vote221 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote222 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote235 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote210 views1 answer
AddEntityFrameworkSqlite
SQL