/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

13 votes247 views2 answers
Get tables in database sql
SQL
3 votes246 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote241 views1 answer
If column value is null then in mysql
SQL
0 vote222 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote246 views1 answer
OFFSET consulta mysql
SQL
9 votes238 views1 answer
Oracle get table schema
SQL
0 vote240 views1 answer
Database traccar
SQL
0 vote239 views1 answer
Mysql select smaller of two values
SQL
1 vote226 views1 answer
Mysql show current queries
SQL
0 vote268 views1 answer
Get initial in sql
SQL