QGIS » QGIS Application

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.

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);