[GRASS-user] GRASS6.2.1+QGIS0.9_db.connect

Hi at all,

I have a problem with the module "db.connect" in QGIS0.9
When I import a OGR file like a SHP the same file is created
in table postgres, why?

How i can to disconnect driver pg from my mapset in GRASS?

Thank you and sorry my english!
--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14107399
Sent from the Grass - Users mailing list archive at Nabble.com.

Salvator*eL*arosa wrote:

Hi at all,

I have a problem with the module "db.connect" in QGIS0.9
When I import a OGR file like a SHP the same file is created
in table postgres, why?

How i can to disconnect driver pg from my mapset in GRASS?

Thank you and sorry my english!

what does
db.connect -p
report (print current settings)?

You could set to a different driver:
http://grass.itc.it/grass63/manuals/html63_user/db.connect.html

Markus
--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14108799
Sent from the Grass - Users mailing list archive at Nabble.com.

Markus Neteler wrote:

what does
db.connect -p
report (print current settings)?

You could set to a different driver:
http://grass.itc.it/grass63/manuals/html63_user/db.connect.html

Markus

Thanks for reply

db.connect -p:

driver:pg
database:host=localhost,dbname=cms
schema:public
group:(null)

I tried to change to:

driver:dbf
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)

but import module get me this error:

Table '(null).bacini' linked to vector did not exist.
Layer: bacini
DBMI-DBF driver error:
SQL parser error in statement:
create table (null).bacini (cat integer, ID double precision, GEOMETRY_S
varchar ( 254 ), AREE varchar ( 254 ), NOME varchar ( 254 ))
Error in db_execute_immediate()

Cannot create table: create table (null).bacini (cat integer, ID double
precision, GEOMETRY_S varchar ( 254 ), AREE varchar ( 254 ), NOME varchar (
254 ))

What you think about it?

--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14110345
Sent from the Grass - Users mailing list archive at Nabble.com.

I experienced something like that a few weeks ago. Is windows your OS?
Any way, I just edited the VAR file in my mapset to remove the last two lines:
schema:(null)
group:(null)

It worked the next time I opened GRASS or QGIS in that mapset.

----- Original Message ----- From: "Salvator*eL*arosa" <s_larosa@libero.it>
To: <grass-user@lists.osgeo.org>
Sent: Saturday, December 01, 2007 5:26 PM
Subject: Re: [GRASS-user] GRASS6.2.1+QGIS0.9_db.connect

Markus Neteler wrote:

what does
db.connect -p
report (print current settings)?

You could set to a different driver:
http://grass.itc.it/grass63/manuals/html63_user/db.connect.html

Markus

Thanks for reply

db.connect -p:

driver:pg
database:host=localhost,dbname=cms
schema:public
group:(null)

I tried to change to:

driver:dbf
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)

but import module get me this error:

Table '(null).bacini' linked to vector did not exist.
Layer: bacini
DBMI-DBF driver error:
SQL parser error in statement:
create table (null).bacini (cat integer, ID double precision, GEOMETRY_S
varchar ( 254 ), AREE varchar ( 254 ), NOME varchar ( 254 ))
Error in db_execute_immediate()

Cannot create table: create table (null).bacini (cat integer, ID double
precision, GEOMETRY_S varchar ( 254 ), AREE varchar ( 254 ), NOME varchar (
254 ))

What you think about it?

--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14110345
Sent from the Grass - Users mailing list archive at Nabble.com.

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

Salvator*eL*arosa wrote:

Thanks for reply

db.connect -p:

driver:pg
database:host=localhost,dbname=cms
schema:public
group:(null)

I tried to change to:

driver:dbf
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)

The last two lines should be
schema:
group:

Then it will work (best is to use db.connect for such things).

Markus
--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14117195
Sent from the Grass - Users mailing list archive at Nabble.com.

Markus Neteler wrote:

The last two lines should be
schema:
group:

Then it will work (best is to use db.connect for such things).

Markus

Thanks,
I solved by the suggestion of Jonathan!

I have remove the last two lines in VAR and now work fine.

I tried again by db.connect, but without success!
I don't know!

Bye.
--
View this message in context: http://www.nabble.com/GRASS6.2.1%2BQGIS0.9_db.connect-tf4928891.html#a14119989
Sent from the Grass - Users mailing list archive at Nabble.com.