PostgreSQL/PostGIS backend table quoting bug in nested queries

[nino@…]

This issue occurs when using a spatial query as a subselect. The spatial predicate's table alias is quoted when it should not be.

E.g.:

>>> MyGeoTable.objects.filter(geometry__intersects=geom).values_list('fid', flat=True).distinct().query.as_nested_sql()
('SELECT DISTINCT U0."ogc_fid" FROM "my_geo_table" U0 WHERE ST_Intersects("U0"."split", %s)', (<django.contrib.gis.db.backend.postgis.adaptor.PostGISAdaptor object at 0xb6618c2c>,))

In the above ST_Intersects clause, the alias U0 is quoted. This happens here,I believe:
​http://code.djangoproject.com/browser/django/trunk/django/contrib/gis/db/backend/postgis/query.py#L256

I have not patched it yet, as I'm not clear yet how.

[Alex Gaynor]

The issue looks to be that the global quote_name shouldn't be use there, but instead Query.quote_name_unless_alias.

[jaklaassen@…]

I think the attached diffs will fix the problem. GeoWhereNode can pass the quote function through to get_geo_where_clause.

[jbronn]

Confirmed as a bug. A patch to fix this will be available after multi-db support lands.

[Alex Gaynor]

(In [11872]) [soc2009/multidb] Fixed #11741 -- Updates to the spatial backends (e.g., re-enabled POSTGIS_VERSION setting); added geometry backend module. Patch from Justin Bronn.

[Jacob]

Milestone 1.2 deleted