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
