id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
34943	Support passing unique constraint names to bulk_create().	Alex Vandiver	HAMA Barhamou	"#31685 added support for `INSERT ... ON CONFLICT(col1, col2) DO UPDATE SET ...`  In some cases, however, the unique constraint may be on computed columns, which cannot be used with `unique_fields` because they are directly quoted.

For instance:
{{{#!python
from django.db.models.functions import Upper
UserTopic.objects.bulk_create(
  [ut],
  update_conflicts=True,
  update_fields=['last_updated','visibility_policy'],
  unique_fields=['user_profile_id','stream_id',Upper('topic_name')],
)
}}}
...fails because `UserTopic has no field named 'Upper(F(topic_name))'`.

And:
{{{#!python
UserTopic.objects.bulk_create(
  [ut],
  update_conflicts=True,
  update_fields=['last_updated','visibility_policy'],
  unique_fields=['user_profile_id','stream_id','upper(topic_name)'],
)
}}}
...fails similarly, with `UserTopic has no field named 'upper(topic_name)'`.

It would be a useful feature to be able to handle these cases."	New feature	assigned	Database layer (models, ORM)	dev	Normal		bulk insert update upsert	Vitor Pereira Chih Sean Hsu Simon Charette Ülgen Sarıkavak	Accepted	0	0	0	0	0	0