Re: [postgis-users] Error with ST functions

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

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

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" >

[postgis-users] pgpool replication mode (master-master)

Is anyone using Pgpool in replication mode (master-master) with Postgis ? There are not any Pgpool threads in Postgis mailing list for years. When I have got 2 synchronized Psql nodes working together with Pgpool, from time to time there is a Geom query which Pgpool rejects because Psql nodes

Re: [postgis-users] Error with ST functions

> > 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

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

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

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

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

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

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

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,