[nag] Upgrading Nag v1.1.1 to 2.0.2 with Postgres
Vincent Aniello
vincent at hypermeganet.com
Wed May 4 17:37:57 PDT 2005
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
BEGIN
ALTER TABLE
UPDATE 0
ALTER TABLE
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
UPDATE 0
ALTER TABLE
ALTER TABLE
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
UPDATE 0
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
UPDATE 0
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
UPDATE 0
ALTER TABLE
COMMIT
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"
ALTER TABLE
CREATE INDEX
V/
More information about the nag
mailing list