[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