Thank you Bborie, it looks to be working successfully now.
On Fri, Jan 31, 2014 at 10:17 AM, Bborie Park <[email protected]> wrote: > Put the following at the top of your file... > > CREATE TYPE summarystats AS ( > count bigint, > sum double precision, > mean double precision, > stddev double precision, > min double precision, > max double precision > ); > > -bborie > > > On Fri, Jan 31, 2014 at 9:41 AM, Hailey Eckstrand < > [email protected]> wrote: > >> It was from a post on the PostGIS User Discussion that I made last year >> from Pierre Racine: >> >> http://lists.osgeo.org/pipermail/postgis-users/2013-August/037514.html >> >> Is it possible to get this functionality working with PostGIS 2.1? >> >> Thanks, >> Hailey >> >> >> On Fri, Jan 31, 2014 at 9:33 AM, Bborie Park <[email protected]> wrote: >> >>> 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" <[email protected]> >>> 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 <[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 >>>> >>> >>> _______________________________________________ >>> 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
