[Tickets #5949] upgrade from 2.1 to 2.2 is broken for postgres

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5949
-----------------------------------------------------------------------
 Ticket             | 5949
 Created By         | cbs at cts.ucla.edu
 Summary            | upgrade from 2.1 to 2.2 is broken for postgres
 Queue              | Turba
 Version            | 2.2-RC1
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------


cbs at cts.ucla.edu (2007-12-02 00:08) wrote:

Postgres doesn't have CHANGE for ALTER TABLE.  This fails:

    'ALTER TABLE ' . $db_table . ' CHANGE object_name object_lastname
VARCHAR(255)',

It should be:

    'ALTER TABLE ' . $db_table . ' ALTER object_name TYPE VARCHAR(255)',
    'ALTER TABLE ' . $db_table . ' RENAME object_name TO
object_lastname',

Also, 

require_once HORDE_BASE . '/lib/core.php';

I'm guessing needs to be moved up before

require_once 'Horde/CLI.php';

And, lastly, it depends on MDB2 which isn't tested for in any of the
test.php scripts or mentioned in any of the included docs that grep could
find.