[postgis-devel] [PostGIS] #1908: crasher with 2 geography columns in view used in query

PostGIS trac at osgeo.org
Tue Jul 10 10:01:46 PDT 2012


#1908: crasher with 2 geography columns in view used in query
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.2
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 I know.  That's cause I'm still working on a small test to replicate the
 issue.  I'm avoiding the issue in our code at the moment by removing the
 geography columns from the view. None of the sub queries run separately
 triggers the bug. It's only in unison that it crashes.

 I suppose I could try removing the index from the airports table to see if
 its an issue with the index.  Though the query in question I don't think
 ever uses the spatial index.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1908#comment:2>
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