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,
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
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"
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
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"
>
>
> 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:
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
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
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"
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
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
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
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,
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
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
15 matches
Mail list logo