The following bug has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000186 ====================================================================== Reported By: Colin Assigned To: ====================================================================== Project: DBMail Bug ID: 186 Category: installation scripts Reproducibility: always Severity: block Priority: normal Status: new ====================================================================== Date Submitted: 28-Mar-05 12:13 CEST Last Modified: 28-Mar-05 12:13 CEST ====================================================================== Summary: Error running migrate script from 1.2.10 to 2.0.4 Description: I have been running dbmail 1.2.10 (pg 7.3.4-11) for a while now, but the machine I am running on is getting flaky, so I want to upgrade the hardware. I thought I'd update to dbmail 2.0.4 (pg 7.3.4-11) at the sametime.I dumped the database with :pg_dump -f dbmail.all -C dbmail then load with pgsql -U dbmail < dbmail.all When I run the migrate script I get the following output: dbmail=# \i migrate_from_1.x_to_2.0.pgsql BEGIN psql:migrate_from_1.x_to_2.0.pgsql:28: ERROR: Relation'auto_notification_seq' already exists psql:migrate_from_1.x_to_2.0.pgsql:33: ERROR: current transaction isaborted, queries ignored until end of transaction block psql:migrate_from_1.x_to_2.0.pgsql:35: ERROR: current transaction isaborted, queries ignored until end of transaction block psql:migrate_from_1.x_to_2.0.pgsql:40: ERROR: current transaction isaborted, queries ignored until end of transaction block COMMIT BEGIN DROP INDEX DROP INDEX ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE INDEX CREATE INDEX DROP INDEX psql:migrate_from_1.x_to_2.0.pgsql:61: NOTICE: constraint $1 on tablemailboxes depends on index users_id_idx psql:migrate_from_1.x_to_2.0.pgsql:61: ERROR: Cannot drop indexusers_id_idx because other objects depend on it Use DROP ... CASCADE to drop the dependent objects too psql:migrate_from_1.x_to_2.0.pgsql:62: ERROR: current transaction isaborted, queries ignored until end of transaction block psql:migrate_from_1.x_to_2.0.pgsql:63: ERROR: current transaction isaborted, queries ignored until end of transaction block psql:migrate_from_1.x_to_2.0.pgsql:64: ERROR: current transaction isaborted, queries ignored until end of transaction block : : ======================================================================
Bug History Date Modified Username Field Change ====================================================================== 28-Mar-05 12:13Colin New Bug ======================================================================
