/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 vote146 views1 answer
Psql connect to another database
SQL
0 vote136 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote144 views1 answer
Remove transient options sql wordpress
SQL
2 votes140 views1 answer
Query any digits record
SQL
0 vote100 views1 answer
Ms sql unique
SQL
0 vote173 views1 answer
Sqlalchemy orm duplicate
SQL
6 votes123 views4 answers
Sqlite drop table
SQL
0 vote90 views1 answer
Como leer datos de mysql esp32
SQL
0 vote123 views1 answer
Max length found in mysql
SQL
2 votes137 views1 answer
Q operator in sql
SQL