[GRASS-user] Trouble with v.db.join and sqlite
mlennert at club.worldonline.be
Fri May 30 12:30:42 EDT 2008
On 30/05/08 15:17, Markus Neteler wrote:
> On Fri, May 30, 2008 at 1:17 PM, doktoreas <thedoktor78 at gmail.com> wrote:
>> Markus Neteler OSGeo wrote:
>>> can you replicate this with Spearfish or the NC data set?
>>> Then we could easier test things...
>> 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
>> 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
>> 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.
Do I understand correctly that the patch ignores the column if the name
already exists ? Wouldn't it be more "user-friendly" to rename it ?
More information about the grass-user