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

[strk at refractions.net]

Mark, can you look at this ?

As a short-term workaround, in lwgeom_estimate.c line 100:

#define REALLY_DO_JOINSEL 0

--strk;

On Fri, Mar 04, 2005 at 03:01:32AM -0800, Ron Mayer wrote:
> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users