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
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
