I can see why django is crashing at File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql/introspection.py",
line 178, in get_constraints
If I run the query at that line in postgres, I get the following response:
constraint_name | column_name
| constraint_type | array
-------------------------------------------------------+------------------------+-----------------+-----------------------------------
eveshoppinglist_buildline_shopping_list_id_fkey | shopping_list_id
| FOREIGN KEY | {eveshoppinglist_shoppinglist.id}
eveshoppinglist_buildline_item_type_id_fkey | item_type_id
| FOREIGN KEY | {invTypes.typeID}
eveshoppinglist_buildline_build_location_type_id_fkey |
build_location_type_id | FOREIGN KEY | {invTypes.typeID}
eveshoppinglist_buildline_pkey | id
| PRIMARY KEY | {eveshoppinglist_buildline.id}
However, when I fetch the results of that query from python via psycopg2 I
get:
['eveshoppinglist_buildline_shopping_list_id_fkey', 'shopping_list_id',
'FOREIGN KEY', ['eveshoppinglist_shoppinglist.id']]
['eveshoppinglist_buildline_item_type_id_fkey', 'item_type_id', 'FOREIGN
KEY', []]
['eveshoppinglist_buildline_build_location_type_id_fkey',
'build_location_type_id', 'FOREIGN KEY', []]
['eveshoppinglist_buildline_pkey', 'id', 'PRIMARY KEY',
['eveshoppinglist_buildline.id']]
In the 2nd and 3rd rows, the final value is an empty list, but in both
lines should contain 'invTypes.typeID'. Because this result is empty,
used_cols[0] raises an exception.
So what I need to figure out is, why this query response fails to transfer
to python, and is the problem within psycopg2, or is it a bad query from
django. My initial hypothesis is that its because the unmanaged
table+column names are not entirely lower case.
For reference, this occurs with psycopg2 versions 2.6.1 and 2.6.2 and
django 1.10.3 and 1.10.4.
More anon...
>>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/82905960-4433-4a68-84e7-ddc098641142%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
