Hi, 2010/8/13 Nikos Alexandris <[email protected]>: >> --- 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} )" > > + "CREATE UNIQUE INDEX ${table}_cat ON ${table ( ${keycol} )" , > #missing comma? > >> "DROP TABLE ${table}_backup", >> "COMMIT" >> ] >> > sql = tmpl.substitute(table = table, coldef = coltypes, colnames = > colnames)
change to sql = tmpl.substitute(table = table, coldef = coltypes, colnames = colnames, keycol = keycol) Martin -- Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
