/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

4 votes205 views1 answer
Add constraint fk
SQL
6 votes200 views2 answers
Database url postgres
SQL
4 votes215 views1 answer
Phone number sql
SQL
2 votes210 views1 answer
Can you use a where clause for a child query
SQL
3 votes191 views2 answers
Oracle sql drop sequence
SQL
0 vote199 views1 answer
Postgresql add not null and not empty constraint
SQL
1 vote218 views1 answer
Postgresql round double precision
SQL
11 votes205 views2 answers
Set default column value sql
SQL
0 vote208 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
3 votes253 views1 answer
Oracle list invalid password logon denied
SQL