[GRASS-dev] r54684 - db_sqltype_name(): report variable-width string instead of fixed-width n-character string

[Markus Metz]

On Sat, Mar 23, 2013 at 5:37 PM, Martin Landa <landa.martin at gmail.com> wrote:
> Hi,
>
> 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.

Markus Metz