[GRASS-user] v.colors usage [UPDATE]

[Rich Shepard]

On Sat, 3 Nov 2018, Rich Shepard wrote:

>> v.colors -c map=stations use=attr column=site_nbr rgb_col=bin_col --o
> Writing color rules...
> ERROR: Data type of RGB column <bin_col> must be char
>
>  Where have I made the syntactical mistake?

   I slightly modified the command to use a different column:
> v.colors -c map=stations use=attr column=howmany rgb_col=bin_col --o
Writing color rules...
ERROR: Data type of RGB column <bin_col> must be char

Checking that grass saw the postgres table:
> db.connect -p
driver: pg
database: willamette-river-hg
schema: 
group:

Yep, it does.

Looking at the table structure:

> db.describe table=stations
table:stations
description:
insert:?
delete:?
ncols:10
nrows:82
   ...

column:howmany
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:bin_col
description:
type:CHARACTER
len:12
scale:0
precision:0
default:
nullok:yes
select:?
update:?

   So, why does grass tell me the bin_col column needs to be CHAR when it is
(unless grass differentiates between char and CHARACTER.)

Rich