It was from a post on the PostGIS User Discussion that I made last year from Pierre Racine:
http://lists.osgeo.org/pipermail/postgis-users/2013-August/037514.html Is it possible to get this functionality working with PostGIS 2.1? Thanks, Hailey On Fri, Jan 31, 2014 at 9:33 AM, Bborie Park <[email protected]> wrote: > PostGIS 2.1 does not have the data type summarystats. Where did you get > this function? > > PostGIS 2.2 (in development now) does have that data type though for a > built in ST_SummaryStatsAgg function. > > -bborie > On Jan 31, 2014 9:23 AM, "Hailey Eckstrand" <[email protected]> > wrote: > >> Hi bborie, >> >> After changing it from 'SQL' to 'sql' this is the error: >> >> $psql mydb -f ST_SummaryStatsAgg.sql >> >> psql:ST_SummaryStatsAgg.sql:50: ERROR: type summarystats does not exist >> psql:ST_SummaryStatsAgg.sql:56: ERROR: type summarystats does not exist >> psql:ST_SummaryStatsAgg.sql:77: ERROR: type summarystats does not exist >> psql:ST_SummaryStatsAgg.sql:86: ERROR: type "summarystats" does not exist >> psql:ST_SummaryStatsAgg.sql:92: ERROR: type "summarystats" does not exist >> CREATE FUNCTION >> psql:ST_SummaryStatsAgg.sql:121: ERROR: function >> st_summarystatsagg(raster) does not exist >> LINE 8: FROM (SELECT ST_SummaryStatsAgg(rast) as ss, id >> ^ >> HINT: No function matches the given name and argument types. You might >> need to add explicit type casts. >> >> >> Does PostgreSQL 9.3 still have the data type summarystats? Also, the >> function that ST_SummaryStatsAgg.sql relies on, ST_SummaryStats.sql, has it >> remained the same? >> >> Thanks, >> Hailey >> >> >> >> On Fri, Jan 31, 2014 at 6:53 AM, Bborie Park <[email protected]> wrote: >> >>> Can you change line 56 of that code from ... >>> >>> $$ LANGUAGE 'SQL'; >>> >>> to >>> >>> $$ LANGUAGE 'sql'; >>> >>> I believe PostgreSQL 9.3 (maybe 9.2) became case-sensitive with regards >>> to the language. >>> >>> -bborie >>> >>> >>> >>> On Thu, Jan 30, 2014 at 4:41 PM, Hailey Eckstrand < >>> [email protected]> wrote: >>> >>>> Hello, >>>> I've got a new sandbox (Ubuntu 12.04) with a fresh install on >>>> PostgreSQL 9.3 and the following for PostGIS version: >>>> >>>> postgis_full_version >>>> >>>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >>>> POSTGIS="2.1.1 r12113" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, >>>> 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.7.8" >>>> LIBJSON="UNKNOWN" TOPOLOGY RASTER >>>> (1 row) >>>> >>>> >>>> I just ran into a problem where I tried to run ST_SummaryStatsAgg on a >>>> raster for a polygon and ended up with an error. I thought it was b/c I did >>>> not have the function loaded, so when I tried to load the >>>> function ST_SummaryStatsAgg.sql, I got the following errors: >>>> >>>> psql:ST_SummaryStatsAgg.sql:50: ERROR: type summarystats does not exist >>>> psql:ST_SummaryStatsAgg.sql:56: ERROR: language "SQL" does not exist >>>> psql:ST_SummaryStatsAgg.sql:77: ERROR: type summarystats does not exist >>>> psql:ST_SummaryStatsAgg.sql:86: ERROR: type "summarystats" does not >>>> exist >>>> psql:ST_SummaryStatsAgg.sql:92: ERROR: type "summarystats" does not >>>> exist >>>> CREATE FUNCTION >>>> psql:ST_SummaryStatsAgg.sql:121: ERROR: function >>>> st_summarystatsagg(raster) does not exist >>>> LINE 8: FROM (SELECT ST_SummaryStatsAgg(rast) as ss, id >>>> ^ >>>> HINT: No function matches the given name and argument types. You might >>>> need to add explicit type casts. >>>> >>>> Here is the current ST_SummaryStatsAgg that I am trying to load: >>>> >>>> http://hastebin.com/lujenosaro.pas >>>> >>>> Thanks! >>>> >>>> Hailey >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
