On 12/08/10 16:50, Moritz Lennert wrote:
I don't have time right now, but I'll look into adding the index
creation into v.db.dropcol, if you confirm that this is the problem.
Committed to grass6_devbranch as rev 43068.
Candidate for 6.4.1.
For grass7, I think the change should be:
--- 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} )"
"DROP TABLE ${table}_backup",
"COMMIT"
]
But I'll have to update my svn tree first and see if it works, before
committing anything. If anyone wants to go ahead, please feel free.
Moritz
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
