Nested ArrayField with nullable base field generates invalid SQL

[Josef Kolář]

When I have model

class NestedNullableIntegerArrayModel(PostgreSQLModel):
    field = ArrayField(ArrayField(models.IntegerField(null=True)))

and trying to save data

NestedNullableIntegerArrayModel(field=[[None, None], [None, None]]).save()

Django generates

INSERT INTO "postgres_tests_nestednullableintegerarraymodel" ("field") VALUES (%s) RETURNING "postgres_tests_nestednullableintegerarraymodel"."id"

with expectable params

([[None, None], [None, None]], )

but this query fails in postgres on

ERROR:  column "field" is of type integer[] but expression is of type text[]
LINE 1: ...estednullableintegerarraymodel" ("field") VALUES (ARRAY['{NU...
                                                             ^
HINT:  You will need to rewrite or cast the expression.

But, if I use one of values is not None, model is saved successfully:

NestedNullableIntegerArrayModel(field=[[None, None], [None, 42]]).save()

Is it a problem of Django or I should find problem in psycopg?

[Simon Charette]

Not sure if it's a duplicate but it looks related to #24726 at least.

[Marcus Gregersen]

This is due to following bug in psycopg2 ​https://github.com/psycopg/psycopg2/issues/325

[Hasan Ramezani]

Seems bug was fixed in psycopg2. I just added a test case to prove it.

[Mariusz Felisiak]

Bug is fixed in psycopg2 2.7.5+.

[Mariusz Felisiak <felisiak.mariusz@…>]

In 84633905:

Refs #27808 -- Added test for saving nested ArrayField with nullable base field.