/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 vote175 views1 answer
Selecting from a view SQL
SQL
0 vote167 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote159 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote162 views1 answer
Call procedure in wordpress
SQL
0 vote188 views1 answer
Oracle list partitions
SQL
0 vote169 views1 answer
How to order result of subquery in select
SQL
0 vote182 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote188 views1 answer
Mysql extract day from date leading zero
SQL
5 votes161 views6 answers
Sql add days to date
SQL
0 vote161 views1 answer
Mysql show category once count how many products
SQL