[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] ST_Slope
From:       Pierre Racine <Pierre.Racine () sbf ! ulaval ! ca>
Date:       2012-03-29 13:53:31
Message-ID: 87A96661E65C5541AB4D20721C2DD7F8CFBB0CECBC () EXCH-MBX-A ! ulaval ! ca
[Download RAW message or body]

> Attempting to run same query as above:
> SELECT
> ST_Slope(ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0,
> 0, 0.1, 0.1, 0, 0, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) * 10
> + [rast.y]')
> , 1, '8BUI'::text)
> FROM
> nclheights;
> 
> but is still returning "function st_slope(raster, integer, text) does not exist"!

Did you run the postgis_upgrade_20_minor.sql and the rtpostgis_upgrade_20_minor.sql \
scripts?

http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#soft_upgrade


> Thought it could be if I am incorrectly casting the first 8BUI instance so removed
> the first '::text' and error now returns:
> "rt_raster_from_wkb: wkb size (2)  < min size (61)"

That should not happen.

If, still, after upgrade, "function st_slope(raster, integer, text) does not exist", \
you will have to have a look and clean a bit the list of function available in your \
public schema or create a new database and reexecute the .sql files (postgis.sql, \
spatial_ref_sys.sql and rtpostgis.sql).

BTW the FROM part of your query is useless...

Pierre
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]