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

[Bborie Park]

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" <haileyeckstrand at gmail.com>
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 <dustymugs at gmail.com> 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 <
>> 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
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> 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/6915b245/attachment.html>