[postgis-users] ST_Union does not exist

Paul Ramsey pramsey at opengeo.org
Thu May 28 12:18:50 PDT 2009


Operator error? It exists in 1.3.6 as an aggregate, as before. Could
something in your upgrade procedure have dropped it?

P

On Thu, May 28, 2009 at 12:13 PM, Dylan Beaudette
<debeaudette at ucdavis.edu> wrote:
> 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
>



More information about the postgis-users mailing list