Hi everyone! I’ve got a bit of a pickle, hopefully you can help. First: Django 5.0.3, Python 3.10, Postgres back end I have two Models: Criterion and Spell class Criterion(models.Model): value1 = models.IntegerField() value2 = models.IntegerField() operator = models.IntegerField() …

Are you passing the ignore_conflicts option to bulk_create?

It helps confirm I’m not totally crazy, thank you! I’m basically doing what the solution describes there, doing bulk_create on the through model. But repeated entries on that list throw an IntegrityError.

That is helpful indeed, and I saw in the generated SQL that “ON CONFLICT DO NOTHING” is being used as well. That helps me get past the IntegrityError, though now the repeated Criterion are being dropped. I’ll likely have to do some deep diving into what’s actually happening under the hood and possi…

If you just need to know how many times a criterion is repeated on a spell, you could create a custom through class, and store it as an integer, thus avoiding to violate the unique constraint. This will also make the through table smaller, and have better indexing. The documentation for setting a …

Unique constraint on M2M Through

Using Django Using the ORM

coditza March 27, 2024, 5:37pm 2

Would this help?

Topic		Replies	Views
Bulk_create with UniqueConstraint Using the ORM	2	1713	April 24, 2024
Doubt in the usage of bulk_create with update_conflicts=True Using the ORM	3	7262	January 14, 2026
Django ManyToMany with extra fields not working Mystery Errors	5	2158	June 28, 2023
get_or_create UNIQUE constraint error Using the ORM	6	467	November 5, 2024
Clarifying Migration Docs for ManyToManyField → through model (Ticket #35877) ORM	0	51	September 22, 2025

Unique constraint on M2M Through

Related topics