[QGIS-Developer] Failure to load PostGIS raster

[Paolo Cavallini]

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