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 _______________________________________________ Qgis-developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
