[GRASS-user] v.db.join - created fields with only one character long

[Luís Ferreira]

When trying to join a vector table with another table, the created
fields are only type character(1). The original fields to import vary
from 1 to 100 characters.

Is this a bug or I'm not doing something previously necessary?

GRASS 6.4 rev 39766 from SVN
postgresql 8.4.1 from repository
Ubuntu 9.10 

Luís Ferreira




v.db.join map=cos90_clean at cos90 column=leg otable=grass.cos90rcl
ocolumn=codigo

DBMI-Postgres driver error:
Cannot execute:
UPDATE grass.cos90_clean SET codigo=(SELECT codigo
FROM grass.cos90rcl WHERE
grass.cos90rcl.codigo=grass.cos90_clean.leg)
ERROR:  value too long for type character(1)
ERROR: Error while executing: 'UPDATE grass.cos90_clean SET
codigo=(SELECT codigo
FROM grass.cos90rcl WHERE grass.cos90rcl.codigo=grass.cos90_clean.leg)'

DBMI-Postgres driver error:
Cannot execute:
UPDATE grass.cos90_clean SET leg2=(SELECT leg2
FROM grass.cos90rcl WHERE
grass.cos90rcl.codigo=grass.cos90_clean.leg)
ERROR:  value too long for type character(1)
ERROR: Error while executing: 'UPDATE grass.cos90_clean SET leg2=(SELECT
leg2
FROM grass.cos90rcl WHERE grass.cos90rcl.codigo=grass.cos90_clean.leg)'

DBMI-Postgres driver error:
Cannot execute:
UPDATE grass.cos90_clean SET nivel1=(SELECT nivel1
FROM grass.cos90rcl WHERE
grass.cos90rcl.codigo=grass.cos90_clean.leg)
ERROR:  value too long for type character(1)
ERROR: Error while executing: 'UPDATE grass.cos90_clean SET
nivel1=(SELECT nivel1
FROM grass.cos90rcl WHERE grass.cos90rcl.codigo=grass.cos90_clean.leg)'

etc.