<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">I cannot get QGIS to load any features from a PostGIS table. </div><div class=""><br class=""></div><div class="">The connection connects OK, I can see the table with the proposed layer and I fill in the geometry type and SRID.</div><div class="">But it always lists in the legend with feature-count=0</div><div class=""><br class=""></div><div class="">I have stumbled upon something that may be affecting this….</div><div class=""><br class=""></div><div class="">If I tinker with the query builder:</div><div class=""><br class=""></div><div class="">E.g.1 clause: ‘id is not null’ - this returns: “The where clause returned 0 row(s).”</div><div class=""><br class=""></div><div class="">not an error, but there are 7 records in this table, but moreover…...</div><div class=""><br class=""></div><div class="">E.g.2 clause literally: ’not_real_sql' - then I get the message: </div><div class=""><br class=""></div><div class="">“An error occurred when executing the query.</div><div style="margin: 0px;" class="">The data provider said:</div><div style="margin: 0px;" class="">ERROR: column "not_real_sql" does not exist</div><div class="">LINE 1: SELECT * FROM “myschema"."routes" WHERE not_real_sql LIMIT 0”</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Notice the LIMIT 0! </div><div class=""><br class=""></div><div class="">Why is this in the query? surely the clause test button should be reporting how many records are found with this clause, but is in fact forced to zero.</div><div class=""><br class=""></div><div class="">Maybe this SQL is in play elsewhere which is why I see no features ….</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Maybe this is a red-herring…. but thanks for any pointers…</div><div class=""><br class=""></div><div class="">Rob</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">
<table border="0" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;" align="center" width="100%" cellspacing="2" cellpadding="0" class="">
<tbody class=""><tr class="">
<td class=""><div style="margin: 0px;" class="">QGIS version</div></td>
<td class=""><div style="margin: 0px;" class="">2.14.15-Essen</div></td>
<td class=""><div style="margin: 0px;" class="">QGIS code branch</div></td>
<td class=""><div style="margin: 0px;" class=""><a href="https://github.com/qgis/QGIS/tree/release-2_14" class=""><span style="color: rgb(0, 0, 255);" class="">Release 2.14</span></a></div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">Compiled against Qt</div></td>
<td class=""><div style="margin: 0px;" class="">4.8.6</div></td>
<td class=""><div style="margin: 0px;" class="">Running against Qt</div></td>
<td class=""><div style="margin: 0px;" class="">4.8.6</div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">Compiled against GDAL/OGR</div></td>
<td class=""><div style="margin: 0px;" class="">2.1.3</div></td>
<td class=""><div style="margin: 0px;" class="">Running against GDAL/OGR</div></td>
<td class=""><div style="margin: 0px;" class="">2.1.3</div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">Compiled against GEOS</div></td>
<td class=""><div style="margin: 0px;" class="">3.6.1-CAPI-1.10.1</div></td>
<td class=""><div style="margin: 0px;" class="">Running against GEOS</div></td>
<td class=""><div style="margin: 0px;" class="">3.6.1-CAPI-1.10.1 r0</div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">PostgreSQL Client Version</div></td>
<td class=""><div style="margin: 0px;" class="">9.3.4</div></td>
<td class=""><div style="margin: 0px;" class="">SpatiaLite Version</div></td>
<td class=""><div style="margin: 0px;" class="">4.3.0a</div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">QWT Version</div></td>
<td class=""><div style="margin: 0px;" class="">6.1.3</div></td>
<td class=""><div style="margin: 0px;" class="">PROJ.4 Version</div></td>
<td class=""><div style="margin: 0px;" class="">492</div></td></tr>
<tr class="">
<td class=""><div style="margin: 0px;" class="">QScintilla2 Version</div></td>
<td class=""><div style="margin: 0px;" class="">2.9.3</div></td>
<td class=""></td>
<td class=""></td></tr></tbody></table><div class=""><br class=""></div></div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>