Re: Upgrading Nag v1.1.1 to 2.0.2 with Postgres

Quoting Jan Schneider <[email protected]>:
> 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/

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