IntegrityError duplicate key value violates unique constraint – django/postgres

by

This happend to me – it turns out you need to resync your primary key fields in Postgres. The key is the SQL statement:

SELECT setval('tablename_id_seq', (SELECT MAX(id) FROM tablename)+1);

More Related Contents:

  1. Django bulk_create with ignore rows that cause IntegrityError?
  2. How to install libpq-fe.h?
  3. How to reset the sequence for IDs on PostgreSQL tables
  4. Django: What are the best practices to migrate a project from sqlite to PostgreSQL
  5. Django: permission denied when trying to access database after restore (migration)
  6. Migrating existing auth.User data to new Django 1.5 custom user model?
  7. Django and postgresql schemas
  8. Docker-compose with django could not translate host name “db” to address: Name or service not known
  9. Different db for testing in Django?
  10. Setting DEBUG = False causes 500 Error
  11. Dynamic File Path in Django
  12. Django – after login, redirect user to his custom page –> mysite.com/username
  13. Use variable as dictionary key in Django template
  14. Create Custom Error Messages with Model Forms
  15. Django delete FileField
  16. Confusion in Django admin, static and media files
  17. What’s the cleanest, simplest-to-get running datepicker in Django?
  18. Django multi-select widget?
  19. Where can I find the error logs of nginx, using FastCGI and Django?
  20. Chaining multiple filter() in Django, is this a bug?
  21. Django : Unable to import model from another App
  22. django.db.utils.IntegrityError: UNIQUE constraint failed: rango_category__new.slug
  23. Django class based view ListView with form
  24. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  25. How to handle “matching query does not exist” when getting an object
  26. Token Authentication for RESTful API: should the token be periodically changed?
  27. Django: Does prefetch_related() follow reverse relationship lookup?
  28. Can I make list_filter in django admin to only show referenced ForeignKeys?
  29. Django Migrations Add Field with Default as Function of Model
  30. Simple Log to File example for django 1.3+

Leave a Comment