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
