[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:
"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.
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

More information about the Qgis-developer mailing list