/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

24 votes110 views6 answers
Sql change table name
SQL
3 votes111 views1 answer
Force using index plsql
SQL
5 votes116 views1 answer
Oracle get foreign keys on table
SQL
7 votes117 views2 answers
Oracle foreign key reference table
SQL
0 vote109 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote110 views1 answer
Oracle sql generate list of days
SQL
3 votes100 views1 answer
Pl sql check if variable is empty
SQL
0 vote187 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote111 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote103 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL