[postgis-users] Error with ST functions

[Lorenzo Bottaccioli]

SELECT extname, extversion from pg_extension;
 extname | extversion
---------+------------
 plpgsql | 1.0
(1 row)


2015-11-19 17:40 GMT+01:00 Sandro Santilli <strk at keybit.net>:

> 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;
> _______________________________________________
> 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/64b367b9/attachment.html>