/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 vote228 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
6 votes143 views2 answers
Postgresql restore from dump
SQL
3 votes174 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
4 votes168 views5 answers
Get last query in codeigniter 4
SQL
1 vote136 views1 answer
How to test for sql injection
SQL
16 votes177 views4 answers
Find duplicates mysql
SQL
3 votes127 views1 answer
Oracle nextval
SQL
1 vote140 views1 answer
Drop function
SQL
1 vote143 views2 answers
Change table name phpmyadmin
SQL
0 vote125 views1 answer
Save single sql query result boolean spring boot
SQL