[GRASS-user] v.reclass and sqlite

[Markus Metz]

On Sun, May 27, 2012 at 5:01 PM, Micha Silver <micha at arava.co.il> wrote:
> Looking at v.dissolve ( which uses v.reclass ) I see that it fails when the
> vector has an sqlite based attribute table:

This sqlite issue should already be fixed in GRASS 7, and v.dissolve
waits for testing before the fix can be backported to GRASS 6.x.
Please test!

Markus M

>
> GRASS 6.4.2 (WGS84):~ > v.db.connect -p test_pg2
> Vector map <test_pg2 at burkina> is connected by:
> layer <1> table <test_pg2> in database
> </home/micha/geodata/grass/WGS84/burkina/sqlite.db> through driver <sqlite>
> with key <cat>
> GRASS 6.4.2 (WGS84):~ > v.info -c test_pg2
> Displaying column types/names for database connection of layer 1:
> INTEGER|cat
> CHARACTER|label
> INTEGER|id
> GRASS 6.4.2 (WGS84):~ > v.reclass test_pg2 out=test_pg2_rcl col=label
> WARNING: Vector map <test_pg2_rcl> already exists and will be overwritten
> DBMI-SQLite driver error:
> Cannot step:
> SQL logic error or missing database
>
> ERROR: Unable to fetch data from table <test_pg2>
> GRASS 6.4.2 (WGS84):~ >
>
>
> This, of course causes v.dissolve to fail.  Is this an sqlite limitation?
>
> (WHen I copied the same vector to a new one with dbf based attrib table,
> v.reclass worked fine)
>
> Thanks,
>
> Micha
>
> --
> Micha Silver
> GIS Consultant, Arava Development Co.
> http://www.surfaces.co.il
>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>