Hi Moritz - the SQLite DB seems to be inheriting the schema from the previous PG driver? Even if I db.dropdb…. I don’t encounter this if I create a new location… e.g. test
GRASS 7.0.0svn (nodeclean):~ > db.dropdb database='/var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db' GRASS 7.0.0svn (nodeclean):~ > db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' GRASS 7.0.0svn (nodeclean):~ > db.connect -p driver: sqlite database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db schema: grass group: grass70 -text -c EPSG:3577 /var/tmp/test GRASS 7.0.0svn (test):~ > db.connect -p driver: sqlite database: /var/tmp/test/PERMANENT/sqlite/sqlite.db schema: group: On 12 Feb 2015, at 7:05 pm, Moritz Lennert <mlenn...@club.worldonline.be> wrote: On 12/02/15 02:14, Mark Wynter wrote: > > #(2) RESET THE DATABASE DRIVER FOR THE CURRENT MAPSET TO SQLITE > db.connect driver=sqlite > database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' schema=grass > db.connect -p > > #Output > driver: sqlite > database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db > schema: grass > group: [...] > #(5) Run v.net.allpairs…. > g.remove -f type=vector pattern="temp**" > v.net.allpairs --overwrite in=nsw_road_network_final_connected_copy > cats=1-10 out=temp_8 afcolumn=fwdcost abcolumn=bwdcost > DBMI-SQLite driver error: > Error in sqlite3_prepare(): > unknown database grass > > DBMI-SQLite driver error: > Error in sqlite3_prepare(): > unknown database grass I don't think SQLite supports schemas. Moritz
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
