/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

1 vote328 views3 answers
Mysql disable foreign keys check
SQL
0 vote398 views1 answer
Sql query to select even numbers
SQL
2 votes352 views2 answers
How to create an empty table from an existing table
SQL
0 vote335 views1 answer
Import big data to mysql
SQL
6 votes357 views1 answer
How to get the size of the database in postgresql
SQL
0 vote383 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote357 views1 answer
Capabilities of sql select statements
SQL
1 vote326 views2 answers
Sql multiline comment
SQL
12 votes339 views1 answer
Psql drop column
SQL
1 vote331 views1 answer
Select inside insert query
SQL