/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 vote111 views1 answer
Sql insert tuple
SQL
1 vote144 views1 answer
Mysql print variable
SQL
3 votes128 views2 answers
Oracle apex view logs
SQL
0 vote126 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote154 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
2 votes128 views2 answers
Mysql add hours to time field
SQL
0 vote120 views1 answer
Select the date 30 days less that the todays date sql request
SQL
14 votes125 views2 answers
Oracle export trigger ddl
SQL
2 votes133 views1 answer
Power query concatenate
SQL
0 vote115 views1 answer
Top frequency in sql server
SQL