Hi, On 25 March 2013 09:49, Markus Metz <[email protected]> wrote: > On Sat, Mar 23, 2013 at 5:37 PM, Martin Landa <[email protected]> wrote: >> Hi, >> >> 2013/3/21 Markus Metz <[email protected]>: >>> 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. > With sqlite3, all CHARACTER(%d)s, VARCHAR(%d)s, etc. become TEXT. [1] Vaclav [1] http://www.sqlite.org/datatype3.html _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
