[postgis-users] Re: two different geometries with the same Astext

[strk at refractions.net]

On Thu, Jul 21, 2005 at 12:47:53PM -0300, Miguel de la Fuente wrote:
> Well, now we're getting to something.
> 
> When I run
> -- SELECT postgis_full_version()
> 
> I get
> 
> POSTGIS="1.0.0RC3" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004"
> USE_STATS DBPROC="0.2.0" RELPROC="0.2.0""
> 
> So you're right, I'm using an old version wich has this bug not fixed.
> 
> However, I run
> 
> -- SELECT within(addbbox(dropbbox(g1)), addbbox(dropbbox(g2)))
> 
> and it return TRUE

Mmm.. this doesn't confirm your problem is the box3d computation bug.

The addbbox(dropbbox()) call has the only effect of re-computing
the cached bounding box.

Are you sure about your tests ? I summarize them:

	1) within: false
	2) within(dropbbox): true
	3) within(addbbox(dropbbox)): true

The above with exactly the same input data.

> Then I just must upsdate POSTGIS, and that would be the whole
> solution. doesn't it?

If you update to 1.0.3 a dump/reload would be required and
any dump/reload would recompute bounding boxes so you should
be ok.

> Thank you very much.
> 
> One last thing, Could you tell me how to update the POSTGIS or why you
> asked me if I ever had an older version installed??
> 
> Thanks a lot.

Upgrade process is described in postgis manual, online:
http://postgis.refractions.net/docs/ch02.html#upgrading

I asked about an older version installed because the old/bogus
version might have created corrupted bounding boxes which would
not be fixed by a simple (non dump/reloading) upgrade.

--strk;

> 
> 
> On 7/20/05, strk at refractions.net <strk at refractions.net> wrote:
> > postgis_full_version()
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users