[postgis-tickets] [PostGIS] #2543: invalid join selectivity error from simple query

PostGIS trac at osgeo.org
Tue Nov 12 14:55:04 PST 2013


#2543: invalid join selectivity error from simple query
--------------------------+-------------------------------------------------
 Reporter:  paulfriedman  |       Owner:  pramsey      
     Type:  defect        |      Status:  new          
 Priority:  blocker       |   Milestone:  PostGIS 2.1.1
Component:  postgis       |     Version:  2.1.x        
 Keywords:                |  
--------------------------+-------------------------------------------------
 query:

 select  1
 from
    repository.bay_grid1000 k,
    reference.ca_region r
 where
    st_intersects(k.geom, r.geom);

 error:

 ERROR:  invalid join selectivity: 1.000000
 ********** Error **********

 ERROR: invalid join selectivity: 1.000000
 SQL state: XX000

 All tables were freshly analyzed/vacuumed and no luck.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2543>
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