[postgis-users] Problem with intersection from postgresql 8.0.7 to 8.1.3 win32

[strk at refractions.net]

On Sat, Feb 18, 2006 at 04:04:58PM -0300, René F. Viancos S. wrote:
> I have tried with the following SQL sentence (posrgreSQL 8.1.7)
> POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004"
> USE_STATS DBPROC=" 0.3.0" RELPROC="0.3.0"
> 
> SELECT DISTINCT(astext(intersection((SELECT astext(collect(the_geom)) as
> the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS NOGALES'), (SELECT
> astext(collect(the_geom)) as the_geom FROM r13_ejes_32719 WHERE nombre =
> 'LOS RECUERDOS')))) FROM r13_ejes_32719 WHERE (nombre = 'LOS NOGALES' OR
> nombre = 'LOS RECUERDOS');
> 
> and the output is the following:
> 
> ERROR:  GEOS Intersection() threw an error!
> 
> i´have a question, how can i compile postgis 0.9.2 linked with geos on
> fedora 4 ? i have doengraded to geos 2.1.1, like the package of postgreSQL
> 8.0.3 for win32 and the preserves the error, but i don't know how to compile
> postgis 0.9.2 linked with GEOS 2.1.1 on fedora 4.

You don't want to use postgis 0.9.2. 
You want latest postgis release compiled against latest GEOS release.

If the problem persists with them, we'll be happy to look at it.

--strk;