/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 vote301 views1 answer
1 column values in to 1 single row in sql
SQL
1 vote307 views1 answer
What is intersect
SQL
0 vote341 views1 answer
What is database username and password in mysqliconnect
SQL
11 votes305 views2 answers
Docker create postgres db
SQL
19 votes318 views5 answers
Change column name mysql command line
SQL
57 votes547 views5 answers
How to create a new user in postgresql
SQL
0 vote329 views2 answers
Psql commande \gset
SQL
0 vote333 views1 answer
Set column in all row mysql
SQL
0 vote309 views1 answer
Laravel eloquent get generated sql
SQL
0 vote322 views1 answer
Mysql export search results
SQL