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 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users