Hi Pietro, On Thu, Oct 25, 2012 at 3:23 PM, Pietro Rossin <[email protected]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giuseppe Sucameli - Faunalia _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
