On Fri, 30 May 2008 04:17:51 -0700 (PDT) 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 > > Luca
Luca, v.db.join never worked for me when the columns had the same name. I rename one of the columns and there is no problem. I was also wondering if there is a reason for that or if it is a bug. in your case rename one of the "cat" columns to lets say "cat_x" and do: v.db.join map=urbanarea column=cat otable=urban_point ocolumn=cat_x Nikos _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
