[postgis-users] Collecting Polygons

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users