[GRASS-user] v.rast.stats is error while executing: 'BEGIN TRANSACTION'

Markus Neteler neteler at osgeo.org
Sat Dec 27 15:56:41 PST 2014

Dear Chingchai,

sorry for the delay. I have fixed the script (at least it no longer
fails in my tests here). Please try the updated script from here:

Comment: Instead of trying to add SQL TRANSACTIONS to the DBF driver,
I have now simply conditionalized it in r63789. This fixed script will
ship with the future GRASS GIS 6.4.5.


On Wed, Oct 22, 2014 at 12:08 PM, Markus Neteler <neteler at osgeo.org> wrote:
> On Sun, Oct 19, 2014 at 11:54 PM, Markus Neteler <neteler at osgeo.org> wrote:
>> On Wed, Oct 15, 2014 at 6:16 PM, chingchai humhong
>> <chingchai.h at gmail.com> wrote:
>>> Hi all,
>>> I'm new to GIS and also new to GRASS GIS.
>> Welcome here!
>>> I want to zonal statistics from
>>> raster map rainfall interpolation(idw) on basin vector polygon. I used
>>> v.rast.stats. But there are problems
>>> v.rast.stats -c vector=basin_250 at PERMANENT raster=rainfall_idw at PERMANENT
>>> colprefix=z
>>> Updating the database ...
>>> DBMI-DBF driver error:
>>> SQL parser error: syntax error, unexpected NAME processing
>>> 'BEGIN'
>>> in statement:
>>> Error in db_execute_immediate()
>>> ERROR: Error while executing: 'BEGIN TRANSACTION'
>>> Thank you.
>> ok, the issue is that the DBF driver does not support SQL
>> transactions. I thought that this would be automatically handled.
> I was able to reproduce the issue.
> I'm trying to address that now in
> http://trac.osgeo.org/grass/ticket/2457
> Markus

More information about the grass-user mailing list