Upgrading Mnemo v1.1.2 to 2.0.1 with Postgres

I am using Postgres 7.4.1 and trying to upgrade Mnemo v1.1.2 to v2.0.1.  The SQL
script 1.1_to_2.0.mysql.sql is included to upgrade the database for the new
version, but this script is for MySQL.  Can someone provide an upgrade script
that works with Postgres?

When I try running the SQL script for MySQL included with Mnemo 2.0.1 I get the
following errors:

-bash-2.05b$ psql -d horde -f 1.1_to_2.0.mysql.sql
ALTER TABLE
psql:1.1_to_2.0.mysql.sql:11: ERROR:  adding NOT NULL columns is not implemented
HINT:  Add the column, then use ALTER TABLE SET NOT NULL.
psql:1.1_to_2.0.mysql.sql:13: ERROR:  syntax error at or near "CHANGE" at
character 25
psql:1.1_to_2.0.mysql.sql:14: ERROR:  syntax error at or near "CHANGE" at
character 25
psql:1.1_to_2.0.mysql.sql:15: ERROR:  syntax error at or near "CHANGE" at
character 25
psql:1.1_to_2.0.mysql.sql:17: ERROR:  column "memo_uid" does not exist


Any help would be appreciated.

Thanks.

V/
-- 
Mnemo mailing list - Join the hunt: http://horde.org/bounties/#mnemo
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]