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

[René F. Viancos S.]

i have solved the problem.

in postgis 1.0.4 the collect function does not accept GeometryCollection
arguments, i have tried with HOSTGIS Linux and it version of postgres,
giving the following error (more complete)

NOTICE:  IllegalArgumentException: This method does not support
GeometryCollection arguments


ERROR:  GEOS Intersection() threw an error!

with this in mind, i have replaced the collect function (the work's fine
with the 8.0.3 package of postgresql for win32) by geomunion, and the query
works fine again.

SELECT DISTINCT(astext(intersection((SELECT geomunion(the_geom) as the_geom
FROM r13_ejes_32719 WHERE nombre = 'LOS RECUERDOS'), (SELECT
geomunion(the_geom) as the_geom FROM r13_ejes_32719 WHERE nombre = 'LOS
NOGALES')))) AS the_geom FROM r13_ejes_32719 WHERE (nombre = 'LOS RECUERDOS'
OR nombre = 'LOS NOGALES');

thank strk for your assistance...  case solved...

Best Regards from Chile

René Viancos (-: RENIX :-)



2006/2/18, strk at refractions.net <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;
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



--
René F. Viáncos S.
Director de Geomática y TIC
Vicerrectoría de Investigación y Desarrollo
Universidad de Chile
Tel (56-2) 632 62 09
Cel (56 9) 933 72 66
rviancos at uchile.cl
rviancos at gmail.com
www.investigacion.uchile.cl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060218/97f3a618/attachment.html>