QGIS » QGIS Application

I forgot to say: if I drag and drop a raster layer, or if I use the 'Add to canvas' option, nothing happens. No crash, no loading, really nothing (and the system does not seem busy).

About GDAL, here is what QGIS says in the about window:

Compiled with GDAL/OGR 1.9.0 Used with GDAL/OGR 2.0dev

Giovanni Manghi wrote:

please update to qgis 2.0.1 or master, try again and report back.

Well, as far as I can tell, I'm on the master: that's at least the most recent version available on the Debian repository (see http://qgis.org/debian-nightly/dists/sid/main/binary-amd64/Packages).

master is now tagged 2.1

Giovanni Manghi wrote:

master is now tagged 2.1

But that's not the one available in the official QGIS repository for Debian. Or am I missing something?

Sorry to insist on this, but is there anything I can do using the QGIS official repository for Debian?
Thanks.

With today's update, the QGIS official repository for Debian switched to 2.1.0-Master:

qgis: *** 2.1.0+git20130925+bb63eb1~unstable1 0
904 http://qgis.org/debian-nightly/ sid/main amd64 Packages

However, my problem is still here: I can load vectors (points, lines, polygons), but not rasters from the DB Manager.

The problem is still here with today's update (if anyone's interested):

qgis: *** 2.1.0+git20130930+52ac084~unstable1 0
904 http://qgis.org/debian-nightly/ sid/main amd64 Packages

I can show rasters, except for those registered out-of-db (-R)

Further info: loaded rasters can in general be loaded, whereas those resulting from in-db elaborations (e.g., aspect from DTM) cannot. Right clicking does not do anything, whereas drag & drop on the canvas says:

GDAL provider: Cannot get GDAL raster band:
Raster layer: Provider is not valid (provider: gdal, URI: [etc]

DB Manager complains there is no PK, even though rid is present; however, adding a PK does not solve the problem

Confirmed on 2.4

Now it seems to work, except for -r (out of db) rasters, that crash QGIS

Apparently still valid: the result of st_resample cannot be read.

CREATE TABLE dtm1k
AS SELECT rid, ST_Resample(rast,1000,1000)
AS rast
FROM dtm_single;

Should have been fixed with 27f1d9fb3ebb2445c7bec4350fd5b822d4d718e1 -- can you confirm ?

Is this late fix already in the binaries for Debian?

I still cannot load raster from the DB manager with Debian Jessie (note that I just tried with Windows, and it worked without any problem). I tried with the latest release:

 *** 1:2.8.2+13jessie 0
        904 http://qgis.org/debian/ jessie/main amd64 Packages

as well as the development version:

 *** 1:2.9.0+git20150526+b91e43a+13jessie 0
        904 http://qgis.org/debian-nightly/ jessie/main amd64 

and I get more or less the same error message if I drag and drop, or if I use "Add to canvas":

GDAL provider: Cannot open GDAL dataset PG: `PG' does not exist in the file system, and is not recognised as a supported dataset name.

Raster Layer PG: dbname=<DB> host=xxx user=xxx port=5432 mode=2 schema=env_data column=rast table=etopo1_dem is an invalid layer and cannot be loaded [translated from French...]

(or)

GDAL provider: Cannot obtain the layer from GDAL raster (src/providers/gdal/qgsgdalprovider.cpp : 2521 : initBaseDataset) [translated from French...]

Raster Layer: The provider is invalid (provider gdal, URI : PG: dbname=<DB> host=xxx user=xxx password=xxx port=5432 mode=2 schema=env_data column=rast table=dem_srtm) [translated from French...]
(src/core/raster/qgsrasterlyaer.cpp : 668 : setDataProvider)

Is there anything else I could do to narrow the problem down?

Thank you,
Mathieu.

Edit: GDAL versions, if it helps

gdal-bin:
 *** 1.10.1+dfsg-8+b3 0
        800 http://ftp.us.debian.org/debian/ jessie/main amd64 Packages

libgdal1h:
 *** 1.10.1+dfsg-8+b3 0
        800 http://ftp.us.debian.org/debian/ jessie/main amd64 Packages

Paolo Cavallini wrote:

Now it seems to work, except for -r (out of db) rasters, that crash QGIS

works fine on QGIS 2.8.4, Ubuntu 14.04, pgsql 9.3 and postgis 2.1

Paolo Cavallini wrote:

Apparently still valid: the result of st_resample cannot be read.

CREATE TABLE dtm1k
AS SELECT rid, ST_Resample(rast,1000,1000)
AS rast
FROM dtm_single;

works fine on QGIS 2.8.4, Ubuntu 14.04, pgsql 9.3 and postgis 2.1

even for out of db raster inputs.

not sure about Debian, but on Ubuntu I see no issues here.