/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 vote342 views1 answer
Systems sql
SQL
0 vote346 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
12 votes332 views4 answers
Mysql ifnull
SQL
0 vote283 views2 answers
Delete the last item in a table sql
SQL
0 vote322 views1 answer
Google sheets filter rows above current cell
SQL
0 vote287 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
2 votes328 views2 answers
Get all columns from table sql
SQL
0 vote373 views1 answer
Stored procedure function relation
SQL
0 vote340 views1 answer
Datetime postgres typeorm
SQL
6 votes337 views2 answers
Psql load dump
SQL