/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 vote134 views3 answers
Get all tables postgres
SQL
3 votes128 views1 answer
Search for column name in psql
SQL
2 votes136 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote132 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
3 votes133 views4 answers
Psql list tables in schema
SQL
4 votes122 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote125 views1 answer
Metada in sql
SQL
0 vote146 views1 answer
Soql user profile
SQL
0 vote154 views1 answer
On delete set default
SQL
0 vote147 views1 answer
Oracle lower in where clause
SQL