[GRASS-user] Trouble with v.db.join and sqlite

[Markus Neteler]

Luca,

can you replicate this with Spearfish or the NC data set?
Then we could easier test things...

Markus

On Mon, May 26, 2008 at 9:22 AM, Luca Casagrande
<luca.casagrande at gmail.com> wrote:
> Hello everybody.
>
> I am working with 6.4svn (built yesterday) and got some troubles with
> v.db.join and sqlite.
> If I try to run the command, this is the error reported:
>
>  v.db.join map=aste_geologia at aste_geologia column=link otable=reticolo
> ocolumn=link
>
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> duplicate column name: cat
> ERROR: Error while executing: 'ALTER TABLE aste_geologia ADD COLUMN cat
> INTEGER
> '
> ERROR: Cannot continue (problem adding column).
> ERROR: Cannot continue.
>
> If I try to remove the column cat by hand ( as suggested in a post in the ml),
> it goes fine:
>
> GRASS 6.4.svn (wrme):~ > db.dropcol -f aste_geo_bak colum=cat
> Forcing ...
> WARNING: Deleting <cat> column which may be needed to keep table connected
>         to a vector map
>
> Any idea?
>
> Thank you very much
>
> Luca
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>



-- 
Open Source Geospatial Foundation
http://www.osgeo.org/
http://www.grassbook.org/