Lee, This is a bug in 1.3.2 that was fixed in 1.3.3. I highly suggested upgrading to 1.3.3
The alternative is to work around the bug by using ST_MemCollect instead of ST_Collect. Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Hachadoorian Sent: Thursday, June 19, 2008 9:39 PM To: PostGIS Users Discussion Subject: [postgis-users] Collecting Polygons Hello, I'm having a problem using ST_Collect. Every time (except once) that I try it, it crashes my Postgres server. I am running PostGIS 1.3.2 on Postgres 8.3.0 on WindowsXP. The SQL I am trying to run is: SELECT ST_COLLECT(the_geom) as new_geom, improve_2001 FROM proj_mortgage.geo_li_basics_by_tract WHERE improve_2001 < 10 GROUP BY improve_2001 ; The GROUP BY gives me 10 classes, and the aggregate function apart from ST_Collect works fine. For example, this SQL works: SELECT sum(ST_Area(the_geom)) as tract_area, improve_2001 FROM proj_mortgage.geo_li_basics_by_tract WHERE improve_2001 < 10 GROUP BY improve_2001 ; Any ideas how I can troubleshoot this? Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth & Environmental Sciences CUNY Graduate Center _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
