[Qgis-user] postgis sql query doesn't add as layer

[Giuseppe Sucameli]

Hi Gis Mage,

On Thu, Aug 1, 2013 at 12:38 AM, Gis Mage <gismage at gmail.com> wrote:

> Erroneous query: [...] FROM ""."(select 1 as gid,
> st_setsrid(st_makepoint(10,10),4326) as geo
>
> ) AS ""subQuery_0""" WHERE "geo" IS NOT NULL LIMIT 100) AS t returned 7
> [ERROR:  zero-length delimited identifier at or near """"
>
>
> What's wrong with my query?
>
I'm running QGIS 1.8.0 on OS X
>

that problem was already fixed in master branch (see [1]).
Your query works in QGIS dev/2.0.

To run that query on QGIS 1.8 you must disable "use table estimated
metadata" option from connection settings dialog [2]

Regards.

[1] http://hub.qgis.org/issues/5883
[2] http://hub.qgis.org/issues/5883#note-19


>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>


-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130801/ad0a0ce9/attachment.html>