Hi Alexandre, On Wed, Feb 6, 2013 at 1:42 PM, Alexandre Neto <[email protected]> wrote: > In DBManager SQLWindow [...] > when I try to load it QGIS Canvas (selecting the Id and geometry columns), I > got the following error in the postgis warning tab: > > Erroneous query: SELECT * FROM "(WITH query_1 as (
unfortunately the provider doesn't support to load that statement, it allows SELECT only. Anyway, until it is fixed, you could embed your WITH within a SELECT statement. Regards. > SELECT * > FROM ""PDM"".pdm_compare) > SELECT * > FROM query_1 > )" LIMIT 1 returned 7 [ERROR: relation "(WITH query_1 as ( > SELECT * > FROM "PDM".pdm_compare) > SELECT * > " does not exist > LINE 1: SELECT * FROM "(WITH query_1 as ( > ^ > ] > > I tried using qgis 1.9 and I was able to load the query. Is this a known > problem in 1.8? Is there a workaround so I can use WITH statements in QGIS > 1.8. > > Thanks, > > Alexandre Neto > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Giuseppe Sucameli _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
