[Qgis-user] Can't use Postgres WITH clause (Common Table Expressions) in DBManager in QGIS 1.8

[Giuseppe Sucameli]

Hi Alexandre,

On Wed, Feb 6, 2013 at 1:42 PM, Alexandre Neto <senhor.neto at gmail.com> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Giuseppe Sucameli