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: [email protected] [mailto:[email protected]] On Behalf Of Paul Ramsey Sent: Thursday, May 28, 2009 4:39 PM To: [email protected] 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 <[email protected]> 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 >>> >>> <[email protected]> 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 >>>> [email protected] >>>> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
