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

[doktoreas]

Markus Neteler OSGeo wrote:
> 
> Luca,
> 
> can you replicate this with Spearfish or the NC data set?
> Then we could easier test things...
> 
> Markus
> 
> 

Hi Markus,

those are the steps to replicate the problem with NC dataset ( all is done
in a new mapset called sqlite):

db.connect driver=sqlite
database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
g.copy vect=urbanarea at PERMANENT,urbanarea
v.extract -t input=urbanarea output=urban_point type=point,centroid
v.db.addtable urban_point

v.db.join map=urbanarea column=cat otable=urban_point ocolumn=cat
..
DBMI-SQLite driver error:
Error in sqlite3_prepare():
duplicate column name: cat

ERROR: Error while executing: 'ALTER TABLE urban_point ADD COLUMN cat
       INTEGER
       '
ERROR: Cannot continue (problem adding column).
ERROR: Cannot continue.

Thanks for your help

Luca

-- 
View this message in context: http://www.nabble.com/Trouble-with-v.db.join-and-sqlite-tp17467019p17556544.html
Sent from the Grass - Users mailing list archive at Nabble.com.