[GRASS-dev] Upper case letters for defining columns via v.db.addtable

GRASS GRASS developer
1

Hi,

when I want to specify a column in v.db.addtable, all upper case letters in the column name get converted to lower case. I’m working on GRASS 71 (trunk). Is this an intended behaviour?

v.db.addtable map=myMap table=test layer=3 columns=“My_COL INT”

cheers,

/Johannes

2

Johannes Radinger wrote

Hi,

when I want to specify a column in v.db.addtable, all upper case letters
in
the column name get converted to lower case. I'm working on GRASS 71
(trunk). Is this an intended behaviour?

v.db.addtable map=myMap table=test layer=3 columns="My_COL INT"

cheers,

/Johannes

_______________________________________________
grass-user mailing list

grass-user@.osgeo

http://lists.osgeo.org/mailman/listinfo/grass-user

a quick test here with sqlite as db-backend:

v.db.addcolumn map=mybusstop@user1 columns=My_COL integer

v.db.addcolumn --verbose map=mybusstop@user1 columns=My_COL2 integer
Adding column <My_COL2> to the table

v.db.addcolumn --verbose map=mybusstop@user1 columns=My_COL3 INT
Adding column <My_COL3> to the table

db.columns table=mybusstop
cat
ROUTES
UPDATED
STREET_1
STREET_2
CAMPUS
SHELTER
BENCHES
DISPLAY_MP
SIGNS
RECEPTACLE
COMMENT_
ID
X
Y
Latitude
Longitude
Map_Size
Time_Pt
WWTm_pt
GoTri_Name
MDTm_Pt
My_COL
My_COL2
My_COL3

seems to work here.

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167156.html
Sent from the Grass - Users mailing list archive at Nabble.com.

3

a quick test here with sqlite as db-backend:

also tested with dbf as db-backend:

v.db.addcolumn --verbose map=mybusstopdbf@g7 columns=My_COL4 integer
Adding column <My_COL4> to the table

db.columns table=mybusstopdbf
cat
ROUTES
UPDATED
STREET_1
STREET_2
CAMPUS
SHELTER
BENCHES
DISPLAY_MP
SIGNS
RECEPTACLE
COMMENT_
ID
X
Y
Latitude
Longitude
Map_Size
Time_Pt
WWTm_pt
GoTri_Name
MDTm_Pt
My_COL4

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167161.html
Sent from the Grass - Users mailing list archive at Nabble.com.

4

Hi Helmut,

v.db.addcolumn is also working here.

Can you please test v.db.addtable with columns specified. This module does not work correctly in my case.

/Johannes

···

On Mon, Oct 13, 2014 at 11:44 AM, Helmut Kudrnovsky <hellik@web.de> wrote:

a quick test here with sqlite as db-backend:

also tested with dbf as db-backend:

v.db.addcolumn --verbose map=mybusstopdbf@g7 columns=My_COL4 integer
Adding column <My_COL4> to the table

db.columns table=mybusstopdbf
cat
ROUTES
UPDATED
STREET_1
STREET_2
CAMPUS
SHELTER
BENCHES
DISPLAY_MP
SIGNS
RECEPTACLE
COMMENT_
ID
X
Y
Latitude
Longitude
Map_Size
Time_Pt
WWTm_pt
GoTri_Name
MDTm_Pt
My_COL4

best regards
Helmut

View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167161.html

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

5

Can you please test v.db.addtable with columns specified. This module does

not work correctly in my case.

confirmed. maybe open a ticket.

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167196.html
Sent from the Grass - Users mailing list archive at Nabble.com.

6

Can you please test v.db.addtable with columns specified. This module does

not work correctly in my case.

it's maybe around

http://trac.osgeo.org/grass/browser/grass/trunk/scripts/v.db.addtable/v.db.addtable.py#L106

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Upper-case-letters-for-defining-columns-via-v-db-addtable-tp5167120p5167199.html
Sent from the Grass - Users mailing list archive at Nabble.com.