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
