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

[Nikos Alexandris]

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