[postgis-users] ST_Union does not exist

[Paragon Corporation]

Dylan,

Did it work before?  Aggegates unfortunately don't get upgraded since there
is no CREATE OR REPLACE AGGREGATE logic in PostgreSQL, so if you have been
upgrading the same db prior to 1.3 -- unless you manually run those CREATE
AGGREGATE calls, they won't be there.

 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dylan
Beaudette
Sent: Thursday, May 28, 2009 3:13 PM
To: PostGIS Users Discussion
Subject: [postgis-users] ST_Union does not exist

Hi,

Noticed this today:

-- basic query
SELECT ST_Buffer(ST_UNION(wkb_geometry), 0.1) as wkb_geometry FROM
	(
	SELECT 1 as id, wkb_geometry
	FROM map
	) as a
GROUP BY a.id;

-- error message
ERROR:  function st_union(geometry) does not exist

-- software version (Postgresql 8.3.7)
POSTGIS="1.3.6" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" 
USE_STATS

Could this be related to my recent upgrade from postgis 1.3.3 ? Other
postgis queries seem to work.

I was able to get a result using GeomUnion(geometry)--- but for anything
more than a couple features this would take > 1 hour, not finishing, and
could not be canceled by the user.

Grepping through the source reveals:
/src/postgresql-8.3.7/contrib/postgis-1.3.6$ grep -R -i 'st_union(geometry)'
*

postgis_comments.sql:COMMENT ON AGGREGATE ST_Union(geometry) IS 'args: 
g1field - Returns a geometry that represents the point set union of the
Geometries.';

Ideas?

Dylan


--
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users