[postgis-users] ST_SummaryStatsAgg not working with PostgreSQL 9.3 + PostGIS 2.1.1

[Hailey Eckstrand]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140130/17880757/attachment.html>