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

[Jan Schneider]

Zitat von Vincent Aniello <vincent at hypermeganet.com>:

> Quoting Jan Schneider <jan at horde.org>:
>> http://cvs.horde.org/co.php/nag/scripts/upgrades/1.1_to_2.0.pgsql.sql
>
> When I ran this SQL script it returned a few errors.  The output from
> the script
> follows:
>
> -bash-2.05b$ psql -d horde <1.1_to_2.0.pgsql.sql
> ERROR:  column "task_modified" of relation "nag_tasks" does not exist

That doesn't hurt.

> ERROR:  syntax error at or near "(" at character 50
> ERROR:  syntax error at or near "(" at character 45
> UPDATE 0
> UPDATE 0
> ERROR:  constraint "nag_tasks_pkey" does not exist
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "nag_tasks_pkey" for table "nag_tasks"

I'm not a PostgreSQL expert, so you'll have to play with this on your 
own or hope that someone else knows a more portable statement. You 
could try to use the index creation statement from nag.sql.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/