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