[nag] Upgrading Nag v1.1.1 to 2.0.2 with Postgres

[Vincent Aniello]

I am using Postgres 7.4.1 and trying to upgrade Nag v1.1.1 to v2.0.2.  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 Nag 2.0.2 I get the
following errors:

-bash-2.05b$ psql -d horde -f 1.1_to_2.0.mysql.sql
psql:1.1_to_2.0.mysql.sql:9: ERROR:  column "task_modified" of relation
"nag_tasks" does not exist
psql:1.1_to_2.0.mysql.sql:11: ERROR:  syntax error at or near "CHANGE" at
character 23
psql:1.1_to_2.0.mysql.sql:12: ERROR:  syntax error at or near "CHANGE" at
character 23
psql:1.1_to_2.0.mysql.sql:13: ERROR:  syntax error at or near "CHANGE" at
character 23
psql:1.1_to_2.0.mysql.sql:15: 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:16: 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:18: ERROR:  syntax error at or near "(" at character
50
psql:1.1_to_2.0.mysql.sql:19: ERROR:  syntax error at or near "(" at character
45
psql:1.1_to_2.0.mysql.sql:21: ERROR:  function concat(character varying,
integer) does not exist
HINT:  No function matches the given name and argument types. You may need to
add explicit type casts.
psql:1.1_to_2.0.mysql.sql:22: ERROR:  function concat("unknown", integer) does
not exist
HINT:  No function matches the given name and argument types. You may need to
add explicit type casts.
psql:1.1_to_2.0.mysql.sql:24: ERROR:  syntax error at or near "PRIMARY" at
character 28
psql:1.1_to_2.0.mysql.sql:25: ERROR:  multiple primary keys for table
"nag_tasks" are not allowed
psql:1.1_to_2.0.mysql.sql:27: ERROR:  column "task_uid" does not exist


Any help would be appreciated.

Thanks.

V/


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.