The following bug has been CLOSED ====================================================================== 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: closed ====================================================================== Date Submitted: 28-Mar-05 12:13 CEST Last Modified: 29-Mar-05 14:09 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 : : ======================================================================
---------------------------------------------------------------------- Colin - 28-Mar-05 18:41 CEST ---------------------------------------------------------------------- I deleted the relevant CREATE INDEX lines from my dump file, and the relevat DROP INDEX lines from the migrate script. I'm happy to close this bug. ---------------------------------------------------------------------- paul - 29-Mar-05 14:09 CEST ---------------------------------------------------------------------- Bug closed Bug History Date Modified Username Field Change ====================================================================== 28-Mar-05 12:13Colin New Bug 28-Mar-05 18:41Colin Bugnote Added: 0000638 29-Mar-05 14:09paul Bugnote Added: 0000639 29-Mar-05 14:09paul Status new => closed ======================================================================
