#17884: Distance lookups using ST_Distance_Sphere fails with PostGis 1.5.3
---------------------------------+--------------------------------------
Reporter: ogirardot@… | Owner: nobody
Type: Bug | Status: new
Component: GIS | Version: SVN
Severity: Release blocker | Resolution:
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
---------------------------------+--------------------------------------
Comment (by anonymous):
it makes at least 1.3 and the trunk of 1.4 fail (and crash in my case but
that may be something else) at distance lookups for Postgresql 9.1 and
Postgis 1.5.3 (latest version).[[BR]]
As a matter of fact i can't say that i will be able to put django 1.4 in
production without a proper interaction with postgis...
But i'm not that much familiar with what tags should be on what tickets in
django's trac, if you think that may not be a suitable tag, i can
understand that i just put the tag according to what i think.
But you're right, i don't think it's a regression in Django code, but
evidence points to the fact that the ewkb used and transmitted to
ST_Distance_Sphere does not contain SRID informations. So the oldest
versions of ST_Distance_Sphere (according to the documentation) just
assumed the SRID was 4326, but it seems now it's enforcing it.
So it may not be a regression as the change of behavior comes from
Postgis, but it's not that innocent either to create an EWKB without the
SRID infos.
Regards and sorry for the formatting i couldn't fix it afterwards,
Olivier.
--
Ticket URL: <https://code.djangoproject.com/ticket/17884#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
