[postgis-users] Error with ST functions

[Lorenzo Bottaccioli]

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 <strk at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151120/6f5797fc/attachment.html>