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

[doktoreas]

Markus Neteler OSGeo wrote:
> 
> On Fri, May 30, 2008 at 1:17 PM, doktoreas <thedoktor78 at gmail.com> wrote:
>> 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
> 
> Like this it was easy to replicated.
> (Hopefully) fixed in 6.4.develbranch and 7.trunk.
> 
> You can grab the fixed script also here:
> http://trac.osgeo.org/grass/browser/grass/branches/develbranch_6/scripts/v.db.join/v.db.join
> (download at page bottom)
> 
> Markus
> 
> 

Thanks Markus..
It's funny watching realtime-committing from the IRC channel :)

Building it right now.

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