Re: [postgis-users] Error with ST functions

2015-11-20 Thread 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,

Re: [postgis-users] Error with ST functions

2015-11-20 Thread Paragon Corporation
gis-users@lists.osgeo.org> Subject: Re: [postgis-users] Error with ST functions 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.edific

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Lorenzo Bottaccioli
Hi, (how) did you enable PostGIS for the database you're using ? SELECT postgis_full_version(); --strk; the reuslt of the query is: POSTGIS="2.1.2 r12389" 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.9.1" LIBJSON="UNKNOWN"

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Rémi Cura
As an addition, you need to have the public schema in your search path, at least. It is the case by default, unless you tweeked it. SET search_path TO 'public' ; Cheers, Rémi-C 2015-11-18 19:59 GMT+01:00 Sandro Santilli : > On Wed, Nov 18, 2015 at 07:54:19PM +0100, Lorenzo

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Sandro Santilli
On Thu, Nov 19, 2015 at 11:33:12AM +0100, Lorenzo Bottaccioli wrote: > *ERROR: function st_bandisnodata(raster) does not exist* [..] > POSTGIS="2.1.2 r12389" 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.9.1" >

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Lorenzo Bottaccioli
> > How about these: > > SELECT > n.nspname, p.proname, array_agg(t.typname) > FROM > pg_proc p, pg_namespace n, pg_type t > WHERE p.proname = 'st_bandisnodata' >AND n.oid = p.pronamespace >AND t.oid = any (p.proargtypes) > GROUP BY >n.nspname, p.proname, p.oid; > response:

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Lorenzo Bottaccioli
SELECT extname, extversion from pg_extension; extname | extversion -+ plpgsql | 1.0 (1 row) 2015-11-19 17:40 GMT+01:00 Sandro Santilli : > On Thu, Nov 19, 2015 at 02:00:05PM +0100, Lorenzo Bottaccioli wrote: > > > > > > How about these: > > > > > > SELECT

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Sandro Santilli
On Thu, Nov 19, 2015 at 02:00:05PM +0100, Lorenzo Bottaccioli wrote: > > > > How about these: > > > > SELECT > > n.nspname, p.proname, array_agg(t.typname) > > FROM > > pg_proc p, pg_namespace n, pg_type t > > WHERE p.proname = 'st_bandisnodata' > >AND n.oid = p.pronamespace > >AND

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Sandro Santilli
On Thu, Nov 19, 2015 at 05:53:47PM +0100, Lorenzo Bottaccioli wrote: > SELECT extname, extversion from pg_extension; > extname | extversion > -+ > plpgsql | 1.0 > (1 row) [...] > POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel.4.8.0, 6 March > 2012"

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Lorenzo Bottaccioli
Postgis installed by ubuntu repository, then createdb mydb psql -d mydb -f postgis_comments.sql psql -d mydb -f spatial_ref_sys.sql psql -d mydb -f rtpostgis.sql psql -d mydb -f raster_comments.sql psql -d mydb -f topology.sql psql -d mydb -f topology_comments.sql 2015-11-19 18:03 GMT+01:00

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Sandro Santilli
On Thu, Nov 19, 2015 at 06:10:52PM +0100, Lorenzo Bottaccioli wrote: > Postgis installed by ubuntu repository, then > > createdb mydb > psql -d mydb -f postgis_comments.sql > psql -d mydb -f spatial_ref_sys.sql > psql -d mydb -f rtpostgis.sql > psql -d mydb -f raster_comments.sql > psql -d mydb

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Lorenzo Bottaccioli
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) $$ 2015-11-19

Re: [postgis-users] Error with ST functions

2015-11-19 Thread Sandro Santilli
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,

[postgis-users] Error with ST functions

2015-11-18 Thread Lorenzo Bottaccioli
Hello, I'm a new PostGis user so I might do some stupid questions. I have problem with all most every ST function. I'f I type this query: *SELECT ST_BandIsNoData(rast) from mytable;* I get this result *ERROR: function st_bandisnodata(raster) does not exist* *LINE 1: SELECT

Re: [postgis-users] Error with ST functions

2015-11-18 Thread Sandro Santilli
On Wed, Nov 18, 2015 at 07:54:19PM +0100, Lorenzo Bottaccioli wrote: > *ERROR: function st_bandisnodata(raster) does not exist* > *LINE 1: SELECT ST_BandIsNoData(rast) from mytable;* > * ^* > *HINT: No function matches the given name and argument types. You might > need to add