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