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

[Bborie Park]

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 <haileyeckstrand at gmail.com
> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140131/8df53118/attachment.html>