diff options
Diffstat (limited to 'django/contrib/postgres/fields/array.py')
| -rw-r--r-- | django/contrib/postgres/fields/array.py | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/django/contrib/postgres/fields/array.py b/django/contrib/postgres/fields/array.py index 3edc72ac94..c247387eb7 100644 --- a/django/contrib/postgres/fields/array.py +++ b/django/contrib/postgres/fields/array.py @@ -237,7 +237,9 @@ class ArrayField(CheckFieldDefaultMixin, Field): class ArrayRHSMixin: def __init__(self, lhs, rhs): - if isinstance(rhs, (tuple, list)): + # Don't wrap arrays that contains only None values, psycopg2 doesn't + # allow this. + if isinstance(rhs, (tuple, list)) and any(self._rhs_not_none_values(rhs)): expressions = [] for value in rhs: if not hasattr(value, "resolve_expression"): @@ -256,6 +258,13 @@ class ArrayRHSMixin: cast_type = self.lhs.output_field.cast_db_type(connection) return "%s::%s" % (rhs, cast_type), rhs_params + def _rhs_not_none_values(self, rhs): + for x in rhs: + if isinstance(x, (list, tuple)): + yield from self._rhs_not_none_values(x) + elif x is not None: + yield True + @ArrayField.register_lookup class ArrayContains(ArrayRHSMixin, lookups.DataContains): |