[postgis-users] ST_Union does not exist

[Paragon Corporation]

Yap I complained about this eons ago and I don't think we ever got to fixing
it.

http://postgis.refractions.net/pipermail/postgis-users/2007-August/016813.ht
ml 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Thursday, May 28, 2009 4:39 PM
To: dylan.beaudette at gmail.com
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] ST_Union does not exist

I think we need to have a careful look at the upgrade script, sounds like
taht is the source of some pain.


On Thu, May 28, 2009 at 1:35 PM, Paul Ramsey <pramsey at opengeo.org> wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users