[postgis-users] ST_Union does not exist

[Paul Ramsey]

open lwpostgis.sql and look for ST_Union. I see the aggregate def'n in  
my source. Don't you?
P

On 28-May-09, at 12:59 PM, Dylan Beaudette wrote:

> On Thursday 28 May 2009, Paul Ramsey wrote:
>> Operator error? It exists in 1.3.6 as an aggregate, as before. Could
>> something in your upgrade procedure have dropped it?
>>
>> P
>
> Yeah... I was thinking about that. Why is it that I do not see a  
> CREATE
> AGGREGATE ST_Union(geometry) or anything like that in the source code?
>
> Cheers,
>
> Dylan
>
>
>> 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
>
>
>
> -- 
> Dylan Beaudette
> Soil Resource Laboratory
> http://casoilresource.lawr.ucdavis.edu/
> University of California at Davis
> 530.754.7341