[postgis-users] ERROR: bogus varno: 1 with 8.1beta and postgis 1.0.3 (fwd)

[strk at refractions.net]

On Wed, Aug 31, 2005 at 12:32:55AM -0700, rm_postgis at cheapcomplexdevices.com wrote:
> 
> 
> With psql 8.1beta1 I get a pretty cryptic error message "ERROR: bogus 
> varno: 1"
> occasionally when I try to mix postgis (GIST-based) conditions with normal
> conditions.  The statements where this happen are totally reroducable.
> 
> Attached is an example of this happening.   I'd be happy to look further,
> but I'm not really sure where to look myself; and I must apologize in 
> advance that I'll be traveling for a couple days so my response time for 
> getting more info may be slow.  I'm using the latest postgis and the
> beta of 8.1 on ubuntu.  The previous postgis claims to have some support 
> for 8.1 added; and quite a few statements seem to work fine.
> 
> Any thoughts where I should look next?

Try with:
#define DEBUG_GEOMETRY_STATS 1
in lwgeom_estimate.c around line 28

I tried mixing join condition the_geom && the_geom +
const-based condition the_geom && box +
integer condition serial < 10
No error returned for me (8.1-dev can't remember which date).

--strk;