[postgis-users] ERROR: invalid join selectivity: inf

Ron Mayer rm_postgis at cheapcomplexdevices.com
Fri Mar 4 03:01:32 PST 2005


Ok.. I think I can reproduce this:

 >    fl# select * from rtgr.landpoly,userfeatures.areas
 >        where rtgr.landpoly.the_geom && userfeatures.areas.the_geom;
 >    ERROR:  invalid join selectivity: inf

pretty easily.

Every time I "truncate table userfeatures.areas", and insert
some areas; I'll get that error message until I "analyze areas".

Seems like a bug when the stastics generated by analyze thinks
that a table is empty while in reality it isn't.



More information about the postgis-users mailing list