Answers for "uniqueness violation. duplicate key value violates unique constraint"

SQL
2

postgresql resolv duplicate value violates unique constraint

SELECT setval(pg_get_serial_sequence('users', 'id'), coalesce(max(id)+1, 1), false) FROM users;
Posted by: Guest on December-16-2020
0

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()
Posted by: Guest on December-09-2020

Code answers related to "uniqueness violation. duplicate key value violates unique constraint"

Code answers related to "SQL"

Browse Popular Code Answers by Language