[postgis-users] Backend crashes when collect()ing Box3ds

[strk at refractions.net]

On Wed, Oct 06, 2004 at 03:02:55AM -0700, Ron Mayer wrote:
> 
> On Wed, 6 Oct 2004 strk at refractions.net wrote (quotes re-ordered):
> > The intersets() seems a bug, what GEOS version are you using ?
> 
> On windows, according to postgis_full_version() it was GEOS="2.0.0".
> 
> On linux it was geos-1.0.0 so I'll upgrade that tomorrow too.
> 
> Both versions returned true for:
> 
>   select intersects('BOX3D(-1 -1 -1, 1 1 -2)'::box3d, 
>                     'BOX3D(-1 -1  1, 1 1  2)'::box3d);

mmm.. check how those BOX3d gets casted to a geometry.
The problem might be in the cast only using 2d.

> > Should try 0.9.0 or pgis_0_9_0 CVS branch.
> 
> On the windows machine I used the pre-compiled binary form dcmms
> that was called "postgis-setup-0.9.0-1.exe" yet 
> postgis_full_version() tells me it's "POSTGIS="0.8.2".   Hmm.
> Guess I'll need to learning how to compile something with windows.
> If I figure out how to use a complie on wndows, I'll try GEOS2.0.1 
> there as well.

That's very bad :(
Try also postgis_lib_version() but that should ont change.
Are you sure the library you're using (check probin from pg_proc
where proname = 'postgis_lib_version') is the 0.9.0 one ?

--strk;