<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>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</div><div><br></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><div style="margin: 0px;">GRASS 7.0.0svn (nodeclean):~ > db.dropdb database='/var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db'</div><div style="margin: 0px;">GRASS 7.0.0svn (nodeclean):~ > db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'</div><div style="margin: 0px;">GRASS 7.0.0svn (nodeclean):~ > db.connect -p</div><div style="margin: 0px;">driver: sqlite</div><div style="margin: 0px;">database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db</div><div style="margin: 0px;">schema: grass</div><div style="margin: 0px;">group: </div><div><br></div><div><br></div><div><div style="margin: 0px;">grass70 -text -c EPSG:3577 /var/tmp/test</div></div><div><div style="margin: 0px;">GRASS 7.0.0svn (test):~ > db.connect -p</div><div style="margin: 0px;">driver: sqlite</div><div style="margin: 0px;">database: /var/tmp/test/PERMANENT/sqlite/sqlite.db</div><div style="margin: 0px;">schema: </div><div style="margin: 0px;">group: </div></div></div></div><div><br></div><br><div><div>On 12 Feb 2015, at 7:05 pm, Moritz Lennert <<a href="mailto:mlennert@club.worldonline.be">mlennert@club.worldonline.be</a>> wrote:</div><br class="Apple-interchange-newline"><div>On 12/02/15 02:14, Mark Wynter wrote:<br><blockquote type="cite"><br>#(2) RESET THE DATABASE DRIVER FOR THE CURRENT MAPSET TO SQLITE<br>db.connect driver=sqlite<br>database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' schema=grass<br>db.connect -p<br><br>#Output<br>driver: sqlite<br>database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db<br>schema: grass<br>group:<br></blockquote><br>[...]<br><br><blockquote type="cite">#(5) Run v.net.allpairs….<br>g.remove -f type=vector pattern="temp**"<br>v.net.allpairs --overwrite in=nsw_road_network_final_connected_copy<br>cats=1-10 out=temp_8 afcolumn=fwdcost abcolumn=bwdcost<br>DBMI-SQLite driver error:<br>Error in sqlite3_prepare():<br>unknown database grass<br><br>DBMI-SQLite driver error:<br>Error in sqlite3_prepare():<br>unknown database grass<br></blockquote><br>I don't think SQLite supports schemas.<br><br>Moritz<br></div></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div></body></html>