{"id":1011,"date":"2018-07-03T16:30:54","date_gmt":"2018-07-03T14:30:54","guid":{"rendered":"http:\/\/hannes.enjoys.it\/blog\/?p=1011"},"modified":"2018-07-03T16:30:54","modified_gmt":"2018-07-03T14:30:54","slug":"qgis-no-result-set-with-postgis","status":"publish","type":"post","link":"https:\/\/hannes.enjoys.it\/blog\/2018\/07\/qgis-no-result-set-with-postgis\/","title":{"rendered":"QGIS: &#8220;no result set&#8221; with PostGIS"},"content":{"rendered":"<p>If QGIS tells you &#8220;no result set&#8221; while you are playing around with PostGIS query layers. If your query works fine in the DB Manager but &#8220;Load as Layer&#8221; fails (and not silently with &#8220;invalid PostgreSQL layer&#8221;).<\/p>\n<p><strong>Try turning it off and on again.<\/strong> Restart QGIS. It just might save you many minutes of unreasonable frustration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If QGIS tells you &#8220;no result set&#8221; while you are playing around with PostGIS query layers. If your query works fine in the DB Manager but &#8220;Load as Layer&#8221; fails (and not silently with &#8220;invalid PostgreSQL layer&#8221;). Try turning it off and on again. Restart QGIS. It just might save you many minutes of unreasonable [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,31],"tags":[],"class_list":["post-1011","post","type-post","status-publish","format-standard","hentry","category-postgis","category-qgis"],"_links":{"self":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/1011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/comments?post=1011"}],"version-history":[{"count":2,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/1011\/revisions"}],"predecessor-version":[{"id":1014,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/1011\/revisions\/1014"}],"wp:attachment":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/media?parent=1011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/categories?post=1011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/tags?post=1011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}