[postgis-users] ST_Union does not exist

[Dylan Beaudette]

On Thursday 28 May 2009, Paul Ramsey wrote:
> I think we need to have a careful look at the upgrade script, sounds
> like taht is the source of some pain.

Thanks.


>
> 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



-- 
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341