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
35136	Interoperability with intarray PostgreSQL extension	Jan Hamal Dvořák		"`django.contrib.postgres.lookups` makes use of bare `&&`, `<@` and `@>` operators. The `intarray` extension defines it's own set of these operators specific to `int4[]`. When using `__overlap` and such on a column with `int2[]`, PostgreSQL does not know what operator to use (cannot decide between casting to int4[] and using the generic version) and fails with ""operator is not unique"" error.

This ambiguity could be resolved by using `OPERATOR(pg_catalog.&&)` and such instead of bare `&&` within the `django.contrib.postgres.lookups` module.

We have locally worked around the issue by changing the operators upon startup, but we are not very comfortable with live-patching Django classes as a long-term solution."	New feature	closed	contrib.postgres	dev	Normal	wontfix	postgresql, intarray		Unreviewed	1	0	0	0	0	0