[Qgis-user] load data in Qgis by a query on geom column

[Giuseppe Sucameli]

Hi Pietro,

On Thu, Oct 25, 2012 at 3:23 PM, Pietro Rossin <pierigis at gmail.com> wrote:
> db-manager don't work for me
[[snip]]
> Interrogazione errata: SELECT DISTINCT CASE WHEN
> upper(geometrytype("the_geom")) IN
[[snip]]
> ) AS ""subQuery_0""" WHERE "the_geom" IS NOT NULL LIMIT 100) AS t ha
> restituito 7 [ERROR:  zero-length delimited identifier at or near """"
> LINE 1: ... st_srid("the_geom") FROM (SELECT "the_geom" FROM ""."(SELEC...
> What is that??

DB Manager uses the QGis provider to load the sql-layer.

The bug [1] was in the PG provider and already fixed
22 days ago.
It occurred when trying to load a sql-layer using a connection
with the "use estimated metadata" option checked.

Regards.

[1] http://hub.qgis.org/issues/5883

> @haubourg
>
> FASTSQLLayer plugin works great!
> But It's in user-contributed plugin repo, not official, right?
>
> what do you mean with
>>If you just use WHERE clauses, you can use query builder directly.
> Which query builder? the one that is on the add postgis vector data? With
> that I can only select item from a table, not execute query on geometry
> column, right?
>
> Thankyou all
> Pietro
>
>
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/load-data-in-Qgis-by-a-query-on-geom-column-tp5011161p5011260.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Giuseppe Sucameli - Faunalia