[postgis-tickets] [PostGIS] #2703: KNN gist with recheck for 9.5?

PostGIS trac at osgeo.org
Thu May 21 19:22:59 PDT 2015


#2703: KNN gist with recheck for 9.5?
--------------------------+---------------------------
  Reporter:  robe         |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  high         |  Milestone:  PostGIS 2.2.0
 Component:  postgis      |    Version:  trunk
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 I need to recompile Postgresql 9.5 with latest source to confirm it's not
 bugged here.  My instance is about a week old, but so far not looking
 good. I pulled my airports database of 14,479 someodd records and this
 query makes my instance go BOOM.


 {{{
 -- POSTGIS="2.2.0dev r13538" GEOS="3.5.0dev-CAPI-1.9.0 r4034" PROJ="Rel.
 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24 GDAL_DATA not
 found" LIBXML="2.7.8" LIBJSON="0.12" RASTER

 SELECT * FROM  airports ORDER BY (SELECT geog FROM airports WHERE
 airport_id = 'KBOS') <-> geog limit 10;
 }}}

 Logs just show:


 {{{
 LOG:  server process (PID 7856) was terminated by exception 0xC0000005
 DETAIL:  Failed process was running: SELECT * from airports ORDER BY
 (SELECT geog FROM airports WHERE airport_id = 'KBOS') <-> geog limit 10
 }}}

--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2703#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list