<div dir="ltr"><div><div><div><div><div><div><div>Hi Darrel,<br><br><br></div>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)<br><br></div>Also, there are two ways of adding a raster table to qgis with dbmanager:<br><br></div>1. by right-clicking "Add to Canvas" and<br></div>2. by drag+dropping it to the layers panel.<br><br></div>Method (2) gives more meaningful error messages.<br><br><br></div>Good luck!!<br><br><br></div>Chris<br><div><div><div><br><div><div><br></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Nov 7, 2015 at 2:23 PM, Darrel Maddy <span dir="ltr"><<a href="mailto:darrel.maddy@newcastle.ac.uk" target="_blank">darrel.maddy@newcastle.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="#0563C1" vlink="#954F72" lang="EN-GB">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Dear Regina,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Many thanks for trying to help this is much appreciated.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Unfortunately when I try to add the view or the raster directly in QGIS I get :<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">2015-11-07T13:08:34 0 QGIS starting...<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">2015-11-07T13:08:35 0 Python support ENABLED :-)
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">2015-11-07T13:08:49 0 Application state:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">QGIS_PREFIX_PATH env var: C:/PROGRA~1/QGISPI~1/apps/qgis<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Prefix: C:/PROGRA~1/QGISPI~1/apps/qgis<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Plugin Path: C:/PROGRA~1/QGISPI~1/apps/qgis/plugins<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Package Data Path: C:/PROGRA~1/QGISPI~1/apps/qgis/.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Active Theme Name: default<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Active Theme Path: :/images/themes/default/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">Default Theme Path: :/images/themes/default/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">SVG Search Paths: C:/PROGRA~1/QGISPI~1/apps/qgis/./svg/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">C:/Users/ndm12/.qgis2//svg/<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">User DB Path: C:/PROGRA~1/QGISPI~1/apps/qgis/./resources/qgis.db<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">2015-11-07T13:08:49 0 QGIS Ready!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Times New Roman",serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">This is curious as the original tif file loads without error into QGIS directly.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Running your query returns<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d">postgis_in_action ch01 test rast 27700 None None 2928 2960 True False
1 [u'64BF'] [-9999.0] [False] 0103000020346C00000100000005000000E0CCCCCCB1D517418066666692BE0541E0CCCCCCB1D517418066666692F80C41E0CCCCCCB1681B418066666692F80C41E0CCCCCCB1681B418066666692BE0541E0CCCCCCB1D517418066666692BE0541
True<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d">postgis_in_action ch01 testrast rast 0 None None None None False
False None None None None None False<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></p><span class="HOEnZb"><font color="#888888">
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Darrel<u></u><u></u></span></p>
</font></span></div>
</div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>