[postgis-users] Error with ST functions

[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 t.oid = any (p.proargtypes)
> >  GROUP BY
> >    n.nspname, p.proname, p.oid;
> >
> 
> response:
>  nspname |     proname     |   array_agg
> ---------+-----------------+---------------
>  public  | st_bandisnodata | {bool,raster}
> (1 row)

This isn't the answer you'd get with a fresn install of 2.1.2.
This is:

   nspname |     proname     |     array_agg
  ---------+-----------------+--------------------
   public  | st_bandisnodata | {bool,raster}
   public  | st_bandisnodata | {bool,int4,raster}

You reported postgis_full_version() response of:

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

But didn't say how you enabled it.

SELECT extname, extversion from pg_extension;

--strk;