/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

14 votes125 views4 answers
Online sql compiler
SQL
0 vote118 views1 answer
Create sql table from script inline primary key constraint
SQL
11 votes118 views3 answers
Sql line numbers
SQL
2 votes109 views1 answer
Sqlite show table indexes
SQL
4 votes114 views3 answers
NOT NULL SQL
SQL
0 vote112 views1 answer
Sql file in postgres with pgadmin
SQL
1 vote125 views1 answer
Mariadb alter user host
SQL
1 vote120 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote120 views1 answer
Random name function in mysql for nvarchar
SQL
2 votes119 views1 answer
How to make insert script from table in SQL server
SQL