HI, I'have tried to reinstall postgis. But i still get errors like this one:
SELECT ST_clip(True,polygon.geom, raster.rast) FROM public.edifici as polygon, public.ele1000x1000 as raster; ERROR: function st_clip(boolean, geometry, raster) does not exist LINE 2: ST_clip(True,polygon.geom, raster.rast) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. gis=# SELECT n.nspname, p.proname, array_agg(t.typname) FROM pg_proc p, pg_namespace n, pg_type t WHERE p.proname = 'st_clip' AND n.oid = p.pronamespace AND t.oid = any (p.proargtypes) GROUP BY n.nspname, p.proname, p.oid; nspname | proname | array_agg ---------+---------+-------------------------------------- public | st_clip | {bool,_float8,geometry,raster} public | st_clip | {bool,_int4,_float8,geometry,raster} public | st_clip | {bool,float8,geometry,raster} public | st_clip | {bool,int4,float8,geometry,raster} public | st_clip | {bool,int4,geometry,raster} public | st_clip | {bool,geometry,raster} 2015-11-19 18:38 GMT+01:00 Sandro Santilli <s...@keybit.net>: > On Thu, Nov 19, 2015 at 06:25:46PM +0100, Lorenzo Bottaccioli wrote: > > grep -i st_bandisnodata rtpostgis.sql > > CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, band integer > > DEFAULT 1, forceChecking boolean DEFAULT FALSE) > > CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, forceChecking > > boolean) > > AS $$ SELECT st_bandisnodata($1, 1, $2) $$ > > Right, so someone tempered with the db. > There might be more things missing. > > One way to check what else is missing would be: > > BEGIN; > CREATE EXTENSION postgis VERSION '2.1.2' FROM 'unpackaged'; > -- you'd get an error here, if anything is missing > ROLLBACK; -- we're just checking, right? > > Let me know if you need help with fixing things. > > --strk; > > () Free GIS & Flash consultant/developer > /\ http://strk.keybit.net/services.html >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users