[postgis-users] ST_Union does not exist

Paul Ramsey pramsey at opengeo.org
Thu May 28 13:38:48 PDT 2009


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
>



More information about the postgis-users mailing list