[postgis-users] Collecting Polygons

[Lee Hachadoorian]

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