[postgis-users] NoDataValue

[Bborie Park]

Did you apply the raster constraints on your table?  The view
raster_columns is a constraint-based view so if your table has none of
the constraints expected, there won't be any info in raster_columns.

Use...

SELECT AddRasterConstraints('basin_toscana', 'rast'::name);

-bborie

On 05/30/2012 03:31 AM, Paolo Cavallini wrote:
> Hi all.
> If I
> SELECT nodata_values
> from raster_columns
> where r_table_name='basin_toscana';
> 
>  nodata_values
> ---------------
> 
> (1 riga)
> 
> then
> 
> UPDATE basin_toscana
> SET rast = ST_SetBandNoDataValue(rast,1, 65535);
> 
> why I still get:
> 
> SELECT nodata_values
> from raster_columns
> where r_table_name='basin_toscana';
> 
>  nodata_values
> ---------------
> 
> (1 riga)
> ?
> 
> Also, I get:
> 
> SELECT srid from raster_columns where r_table_name='basin_toscana';
>  srid
> ------
>     0
> (1 riga)
> 
> in spite of having imported with
> 
> raster2pgsql -s 3003 -I -M basin_toscana.tif > basin.sql
> 
> Thanks for any hint.
> All the best.

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu