[GRASS-dev] About v.distance, v.what.vect (wrt "count points within...").

[Moritz Lennert]

On 13/08/10 08:47, Nikos Alexandris wrote:
> Moritz L:
>
>>>> --- v.db.dropcolumn.py  2010-08-12 18:48:03.000000000 +0200
>>>> +++ /home/mlennert/v.db.dropcolumn.py   2010-08-12 18:47:29.000000000
>>>> +0200 @@ -102,6 +102,7 @@
>>>>               "DROP TABLE ${table}",
>>>>               "CREATE TABLE ${table}(${coldef})",
>>>>               "INSERT INTO ${table} SELECT ${colnames} FROM
>>>> ${table}_backup", +           "CREATE UNIQUE INDEX ${table}_cat ON
>>>> ${table ( ${keycol} )"
>
> Nikos A:
>
>>> +              "CREATE UNIQUE INDEX ${table}_cat ON ${table ( ${keycol}
>>> )" , #missing comma?
>>>
>>>>               "DROP TABLE ${table}_backup",
>>>>               "COMMIT"
>>>>               ]
>
>>>     sql = tmpl.substitute(table = table, coldef = coltypes, colnames =
>>> colnames)
>
> Martin L:
>> change to
>>
>> sql = tmpl.substitute(table = table, coldef = coltypes, colnames =
>> colnames, keycol = keycol)
>
> Everything works fine now in grass_trunk, that is:
>
> a. "v.db.dropcolumn" on its own
> b. "v.distance" is fast even after dropping a column (=index is there)
>
> Nikos (happy user today) :D

Committed in trunk as 43083.

Moritz