[postgis-users] Error with ST functions

[Sandro Santilli]

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