/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 vote329 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote320 views1 answer
This week mysql
SQL
0 vote323 views1 answer
Check if database exists sql
SQL
0 vote306 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote328 views3 answers
Query string not ending with with vowels
SQL
0 vote354 views1 answer
Sql date with year
SQL
1 vote367 views2 answers
Intersect sql
SQL
1 vote334 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
-1 vote321 views1 answer
Sql set max value in column
SQL
1 vote332 views1 answer
Postgresql round double precision
SQL