[postgis-users] Error with ST functions

[Lorenzo Bottaccioli]

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 18:23 GMT+01:00 Sandro Santilli <strk at keybit.net>:

> 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 -f topology.sql
> > psql -d mydb -f topology_comments.sql
>
> See if the sourced file did contain that function:
>
>  grep -i st_bandisnodata rtpostgis.sql
>
> You should see this line:
>
>  CREATE OR REPLACE FUNCTION st_bandisnodata(rast raster, band integer
> DEFAULT 1, forceChecking boolean DEFAULT FALSE)
>
> If not, it'd be a broken package.
> If you find it, someone must have removed that function later.
> It should be possible to get it back by:
>
>  psql -d mydb -f rtpostgis_upgrade_21_minor.sql
>
> --strk;
>
>   ()   Free GIS & Flash consultant/developer
>   /\   http://strk.keybit.net/services.html
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151119/0b718807/attachment.html>