[postgis-users] Error with ST functions

[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 <strk at keybit.net>:

> 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 explicit type casts.*
> >
> > Any suggestion how to solve this?
> >
> > I get the same error with many other functions.
>
> (how) did you enable PostGIS for the database you're using ?
> SELECT postgis_full_version();
>
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151119/c516e920/attachment.html>