Feature request #12990

"build virtual vector": add support for postgis/spatialite layers

Added by Giovanni Manghi over 9 years ago. Updated over 6 years ago.

Status:Open
Priority:Normal
Assignee:Victor Olaya
Category:Processing/QGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:21068

Description

Trying to create a virtual vector with postgis/spatialite layers (or anything that is not a shapefile) the tool will return an error.

Virtual vectors with postgis layer as datasources are like

<OGRVRTDataSource>
<OGRVRTLayer name="layer1">
<SrcDataSource>PG:dbname=xxx host=localhost port=5432 user=xxx password=xxx</SrcDataSource>
<SrcLayer>layer1</SrcLayer>
</OGRVRTLayer>
<OGRVRTLayer name="layer2">
<SrcDataSource>PG:dbname=xxx host=localhost port=5432 user=xxx password=xxx</SrcDataSource>
<SrcLayer>layer2</SrcLayer>
</OGRVRTLayer>
</OGRVRTDataSource>

History

#1 Updated by Luigi Pirelli over 9 years ago

may you add the error and (if generated) the erroneous generated format?

#2 Updated by Giovanni Manghi over 9 years ago

Luigi Pirelli wrote:

may you add the error and (if generated) the erroneous generated format?

no output generated, the error is

2015-06-18T10:55:01 2 Invalid datasource: dbname='xxx' host=localhost port=5432 user='xxx' password='xxx' sslmode=disable key='id' table="public"."caop_2013_costa" (geom) sql=
2015-06-18T12:12:31 2 Invalid datasource: dbname='xxx' host=localhost port=5432 user='xxx' password='xxx' sslmode=disable key='id' srid=3763 type=MultiPolygon table="public"."caop_2013_costa" (geom) sql=

where of course "xxx" are the proper connection details.

#3 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#4 Updated by Nyall Dawson over 6 years ago

  • Description updated (diff)
  • Tracker changed from Bug report to Feature request

Also available in: Atom PDF