[Qgis-developer] OGR Buffer fails in Processing

Paolo Cavallini cavallini at faunalia.it
Thu Mar 2 14:34:17 PST 2017


Hi all,
a simple buffer fails if applied to a PostGIS layer:
===
Algorithm Buffer vectors starting...
GDAL command:
ogr2ogr
"/tmp/processingf5bab9b07d834e229b9dd70899b8face/971076e5d374495280a95f7adf2ec92a/OUTPUTLAYER.shp"
"PG:dbname='corso' host=localhost port=5432 user='utente'
password='utente' sslmode=disable" public.fiumi -dialect sqlite -sql
"SELECT ST_Buffer( geometry , 100 ),* FROM 'public.fiumi' "
GDAL command output:
Warning 1: layer names ignored in combination with -sql.
ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT ST_Buffer( geometry ,
100 ),* FROM 'public.fiumi' ):
no such column: geometry
Converting outputs
Caricamento layer

The following layers were not correctly generated.
Buffer
You can check the log messages to find more information about the
execution of the algorithm
===
Whereas it runs fine when applied to a shapefile.
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all&geo=IT&q=qgis,arcgis


More information about the Qgis-developer mailing list