Re: [Django] #36694: PostGIS backend silently ignores most Index options when targeting a single GeometryField (expressions, condition, include, opclasses)

3 views
Skip to first unread message

Django

unread,
Oct 28, 2025, 10:45:35 PM10/28/25
to django-...@googlegroups.com
#36694: PostGIS backend silently ignores most Index options when targeting a single
GeometryField (expressions, condition, include, opclasses)
-------------------------------------+-------------------------------------
Reporter: Luciano de la | Owner: (none)
Iglesia |
Type: Bug | Status: new
Component: GIS | Version: 5.2
Severity: Normal | Resolution:
Keywords: postgis index | Triage Stage: Accepted
condition include |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Simon Charette):

A workaround in the meantime could be to use `expressions=[F("location")]`
instead of `fields=["location"]`. You might have to explicitly specify
[https://www.postgresql.org/docs/current/gist.html the proper] `opclasses`
though, that would be `point_ops` in your case.
--
Ticket URL: <https://code.djangoproject.com/ticket/36694#comment:4>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Oct 29, 2025, 6:41:52 AM10/29/25
to django-...@googlegroups.com
#36694: PostGIS backend silently ignores most Index options when targeting a single
GeometryField (expressions, condition, include, opclasses)
-------------------------------------+-------------------------------------
Reporter: Luciano de la | Owner: Clifford
Iglesia | Gama
Type: Bug | Status: assigned
Component: GIS | Version: 5.2
Severity: Normal | Resolution:
Keywords: postgis index | Triage Stage: Accepted
condition include |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Clifford Gama):

* owner: (none) => Clifford Gama
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/36694#comment:5>

Django

unread,
10:19 AM (3 hours ago) 10:19 AM
to django-...@googlegroups.com
#36694: PostGIS backend silently ignores most Index options when targeting a single
GeometryField (expressions, condition, include, opclasses)
-------------------------------------+-------------------------------------
Reporter: Luciano de la | Owner: Clifford
Iglesia | Gama
Type: Bug | Status: assigned
Component: GIS | Version: 5.2
Severity: Normal | Resolution:
Keywords: postgis index | Triage Stage: Accepted
condition include |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Clifford Gama):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/20541 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/36694#comment:6>
Reply all
Reply to author
Forward
0 new messages