/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 vote198 views1 answer
Restart sql server command line linux
SQL
16 votes207 views1 answer
Sqlserver add column to table
SQL
5 votes306 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
9 votes198 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote203 views2 answers
Oracle sql for each row
SQL
0 vote257 views3 answers
Call to undefined function mysql_connect()
SQL
3 votes230 views1 answer
Oracle cannot access v$session
SQL
22 votes238 views3 answers
Sql cheat sheet
SQL
46 votes287 views4 answers
Create column sql
SQL
0 vote156 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL