Il 23/02/2018 18:54, Paolo Cavallini ha scritto: > Hi all, > list of tables, inlcuding rasters, are correctly displayed in DB > Manager. When double clicking, loading fails with the message: > Cannot open GDAL dataset PG: dbname= > Couldn't establish database connection > In the dialog username and password are requested. > Vectors are loaded correctly. > Anyone confirms?
If someone wants to replicate: ==================================================================== -- create an empty table CREATE TABLE public.test_raster ( rid integer, rast raster, CONSTRAINT enforce_height_rast CHECK (st_height(rast) = ANY (ARRAY[100, 24])), CONSTRAINT enforce_width_rast CHECK (st_width(rast) = ANY (ARRAY[100, 24])), CONSTRAINT enforce_srid_rast CHECK (st_srid(rast) = 4326) ); -- create an empty raster INSERT INTO test_raster(rid,rast) VALUES(1, ST_MakeEmptyRaster( 100, 100, 0.0005, 0.0005, 1, 1, 0, 0, 4326) ); -- add primary key ALTER TABLE test_raster ADD CONSTRAINT test_pkey PRIMARY KEY (rid); ==================================================================== Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all&geo=IT&q=qgis,arcgis _______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer