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_cl...@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. _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user