On 12/02/15 11:16, Mark Wynter wrote:
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

Can you set schema='' or something like that ?

Moritz


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
<mailto: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

Reply via email to