I'm trying to use Postgresql 9.2 Commom Table
Expressions<http://www.postgresql.org/docs/9.2/static/queries-with.html>
in
queries that will be loaded in QGIS 1.8 (windows vista) using DBManager.
Here's a very simple (and useless) example:
WITH query_1 as (
SELECT *
FROM "PDM".pdm_compare)
SELECT *
FROM query_1
In DBManager SQLWindow, I'm able to execute and see the table results, but
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 (
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
