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
