trac-admin upgrade fails on postgresql/sqlite

[anonymous]

Failing line is:

ERROR: WorklogPlugin Exception: ERROR: syntax error at or near "CHANGE" LINE 1: ALTER TABLE client CHANGE COLUMN default_rate default_rate DECIMAL(10,2)

In api.py I did a quick fix, commented out the V6 update, and changed from integer to decimal(10,2)

cursor.execute('CREATE TABLE client ('

'name TEXT,' 'description TEXT,' 'default_rate DECIMAL(10,2),' 'currency TEXT' ')')

cursor.execute('INSERT INTO client SELECT name, description, default_rate, currency FROM client_tmp') cursor.execute('DROP TABLE client_tmp')

#if self.db_installed_version < 6: # print 'Updating clients table (v6)' # cursor.execute('ALTER TABLE client ' # 'CHANGE COLUMN default_rate default_rate DECIMAL(10,2)')

[Colin Guthrie]

Also affects Sqlite. Fix coming shortly.

[Colin Guthrie]

(In [9476]) Apparently SQLite and Postgres don't support much in the way of CHANGE COLUMN statements :(

Here is an ugly workaround for that limitation. Refs #7925