[GRASS-dev] r54684 - db_sqltype_name(): report variable-width string instead of fixed-width n-character string
markus.metz.giswork at gmail.com
Mon Mar 25 01:49:40 PDT 2013
On Sat, Mar 23, 2013 at 5:37 PM, Martin Landa <landa.martin at gmail.com> wrote:
> 2013/3/21 Markus Metz <markus.metz.giswork at gmail.com>:
>> what is the reason for r54684? It breaks a core functionality, i.e.
>> the output of vector_columns in lib/python/scripts/vector.py has now
>> changed and various scripts rely on that output. I have reverted
>> r54684 in 55475. The commit comment does not make sense to me because
>> db_sqltype_name() has never returned the width or precision.
> this change was related to `v.out.postgis` development. Hm, you are
> right. I was not aware enough of possible consequences. I agree with
> this revert.
I noticed that 'CHARACTER' is used whenever the field width is known,
otherwise 'TEXT' is used. IOW, TEXT is what you probably mean with
CHARACTER VARYING. Note that e.g. within sqlite, varchar becomes TEXT
and varchar (%d) becomes CHARACTER.
More information about the grass-dev