[postgis-devel] [PostGIS] #520: No check for different srid on operators when index is used

PostGIS trac at osgeo.org
Fri May 7 03:44:39 PDT 2010


#520: No check for different srid on operators when index is used
----------------------+-----------------------------------------------------
  Reporter:  nicklas  |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.5.2
 Component:  postgis  |     Version:  1.5.X        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by nicklas):

 Mark, you are right, that s what confused me. I just read through it and
 presumed it was some sort of initialization for the index thing.

 So, then I was right from the beginning that there is no check for index
 scans.

 Then, how about the suggestion to remove it also from the actual operator
 function.

 What I mean is
 If it is acceptable for index scans why not when the index is not used.
 The different srids will be found anyway by st_dwithin or whatever is
 using the operator. The case when this might make life easier is when
 comparing geometries with bounding boxes and then you must know what you
 are doing anyway because of the index scan behaviour.


 /Nicklas

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/520#comment:3>
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-devel mailing list