Hi Darrel,
did you save the password for the db connection in qgis' dbmanager? If not you'll get the same error.. (i.e. you are not being prompted for a password again) Also, there are two ways of adding a raster table to qgis with dbmanager: 1. by right-clicking "Add to Canvas" and 2. by drag+dropping it to the layers panel. Method (2) gives more meaningful error messages. Good luck!! Chris On Sat, Nov 7, 2015 at 2:23 PM, Darrel Maddy <darrel.ma...@newcastle.ac.uk> wrote: > Dear Regina, > > > > Many thanks for trying to help this is much appreciated. > > > > I replaced the function as directed (at least I believe I did!). I removed > the table constraints as directed and then created the view as directed. > This was done on my laptop so the names are slightly different as I > inserted the data table into the ch01 schema. > > > > Unfortunately when I try to add the view or the raster directly in QGIS I > get : > > > > 2015-11-07T13:08:34 0 QGIS starting... > > 2015-11-07T13:08:35 0 Python support ENABLED :-) > > 2015-11-07T13:08:49 0 Application state: > > QGIS_PREFIX_PATH env var: C:/PROGRA~1/QGISPI~1/apps/qgis > > Prefix: C:/PROGRA~1/QGISPI~1/apps/qgis > > Plugin Path: C:/PROGRA~1/QGISPI~1/apps/qgis/plugins > > Package Data Path: C:/PROGRA~1/QGISPI~1/apps/qgis/. > > Active Theme Name: default > > Active Theme Path: :/images/themes/default/ > > Default Theme Path: :/images/themes/default/ > > SVG Search Paths: C:/PROGRA~1/QGISPI~1/apps/qgis/./svg/ > > C:/Users/ndm12/.qgis2//svg/ > > User DB Path: C:/PROGRA~1/QGISPI~1/apps/qgis/./resources/qgis.db > > 2015-11-07T13:08:49 0 QGIS Ready! > > 2015-11-07T13:09:32 1 PG: dbname=postgis_in_action port=5433 mode=2 > schema=ch01 column=rast table=testrast is an invalid layer - not loaded > > 2015-11-07T13:18:50 1 PG: dbname=postgis_in_action port=5433 mode=2 > schema=ch01 column=rast table=test is an invalid layer - not loaded > > > > This is curious as the original tif file loads without error into QGIS > directly. > > > > > > Running your query returns > > r_table_catalog r_table_schema r_table_name > r_raster_column srid scale_x > scale_y blocksize_x blocksize_y > same_alignment regular_blocking > num_bands pixel_types > nodata_values out_db extent spatial_index > > postgis_in_action ch01 test rast > 27700 None None 2928 > 2960 True False 1 > [u'64BF'] [-9999.0] [False] > 0103000020346C00000100000005000000E0CCCCCCB1D517418066666692BE0541E0CCCCCCB1D517418066666692F80C41E0CCCCCCB1681B418066666692F80C41E0CCCCCCB1681B418066666692BE0541E0CCCCCCB1D517418066666692BE0541 > True > > postgis_in_action ch01 testrast rast > 0 None None None > None False False None > None None None None False > > > > > > Darrel > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
