[GRASS-dev] How to calculate log() in v.db.update with SQLite backend?
mlennert at club.worldonline.be
Wed Nov 19 23:46:10 PST 2014
On 19/11/14 19:12, Vaclav Petras wrote:
> On Wed, Nov 19, 2014 at 12:59 PM, Markus Neteler <neteler at osgeo.org
> <mailto:neteler at osgeo.org>> wrote:
> DBMI-SQLite driver error:
> Error in sqlite3_step():
> not authorized
> ERROR: Error while executing: 'SELECT
> Traceback (most recent call last):
> Process ended with non-zero return code 1. See errors in the (error)
> No idea what's disliked here in:
> UPDATE meuse_voronoi SET logzinc=log(zinc);
> Any hints?
> Loading user defined function is not considered completely safe, so it
> is disabled by default. I think this is not an issue for GRASS GIS.
> You have to enable it somehow. It seems that enable_load_extension() is
> the way.
But this depends on the installation, i.e. how sqlite3 was compiled.
Here in Debian Testing I do not need to activate anything, so I assume
that it's activated by default.
More information about the grass-dev