[Patch] ClientsPlugin not working with Postgres 8.4

[ricardo.ichizo@…]

The plugin is sending invalid SQL statement to database:

_{postgresql.log}

ERROR:  syntax error at or near "CHANGE" at character 20
STATEMENT:  ALTER TABLE client CHANGE COLUMN default_rate default_rate DECIMAL(10,2)

The correct command must be:

ALTER TABLE client ALTER COLUMN default_rate TYPE DECIMAL(10,2)

The following code resolved this problem:

api.py

@@ -121 +121 @@
             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)')
+                               'ALTER COLUMN default_rate TYPE DECIMAL(10,2)')
             
             #if self.db_installed_version < 7:
             #    print 'Updating clients table (v7)'

[Ryan J Ollos]

Addressed in r9476.