Skip to content

ArrayFields not supported #131

Open
Open
@Augustinio

Description

@Augustinio

Hello,

When trying to export a queryset to csv, I was faced with this error:

  File "/Users/augustinlegalle/.local/share/virtualenvs/medsmart-back-5TZiyDun/lib/python3.7/site-packages/postgres_copy/managers.py", line 220, in to_csv
    data = compiler.execute_sql(csv_path)
  File "/Users/augustinlegalle/.local/share/virtualenvs/medsmart-back-5TZiyDun/lib/python3.7/site-packages/postgres_copy/copy_to.py", line 76, in execute_sql
    c.cursor.copy_expert(copy_to_sql, stdout)
psycopg2.errors.UndefinedFunction: operator does not exist: character varying[] = text[]
LINE 1: ..."practitioners_referencepractitioner"."specialty" IN (ARRAY[...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

This happened right after having performed a migration that changed the previously CharField specialty field into an ArrayField from django.contrib.postgres.fields.

Are ArrayFields not currently supported?
What are my options?

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions