On Fri, May 30, 2008 at 1:17 PM, doktoreas <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED],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 _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
