The following issue has been RESOLVED. ====================================================================== http://dbmail.org/mantis/view.php?id=167 ====================================================================== Reported By: egeschwinde Assigned To: aaron ====================================================================== Project: DBMail Issue ID: 167 Category: Database layer Reproducibility: always Severity: trivial Priority: normal Status: resolved Resolution: fixed Fixed in Version: SVN Trunk ====================================================================== Date Submitted: 25-Jan-05 13:31 CET Last Modified: 24-Mar-06 12:15 CET ====================================================================== Summary: Bug in migration script Description: There is a bug in the migration script in postgresql if there is no CASCADE after the drop index he will fail and the transaction is aborted.
I wrote the cascade at the end of every drop index and commented the alter table drop foreign key $1 out ====================================================================== ---------------------------------------------------------------------- aaron - 05-May-05 07:17 ---------------------------------------------------------------------- I have no clue what this is about. Well, I do, but I don't care. Looks like it should be fixed. Is this an appropriate fix? Anybody? Anybody? Bueller? ---------------------------------------------------------------------- aaron - 08-Feb-06 08:04 ---------------------------------------------------------------------- I still not paying attention to what's going on here. Paul? ---------------------------------------------------------------------- aaron - 24-Mar-06 12:15 ---------------------------------------------------------------------- Ok, I added the CASCADES after the DROP INDEXes. Issue History Date Modified Username Field Change ====================================================================== 25-Jan-05 13:31 egeschwinde New Issue 25-Jan-05 13:31 egeschwinde File Added: migration2.sql 05-May-05 07:17 aaron Note Added: 0000677 08-Feb-06 08:04 aaron Note Added: 0000995 24-Mar-06 12:15 aaron Status new => resolved 24-Mar-06 12:15 aaron Fixed in Version => SVN Trunk 24-Mar-06 12:15 aaron Resolution open => fixed 24-Mar-06 12:15 aaron Assigned To => aaron 24-Mar-06 12:15 aaron Note Added: 0001049 ======================================================================
