Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004706 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | minor | always | 2008-08-25 17:29 | 2009-03-18 11:02 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 106 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004706: DROP TABLE CASCADE statements cause DROP VIEW statements to fail | |||||||
| Description | If a view depending on a table and that table have to be dropped when updating the database, there will be an error. This error happens because the DROP TABLE statement containts a CASCADE clause, that in turn forces the database to drop the view. Afterwards, dbsourcemanager tries to delete the view, which causes the error, as the view no longer exists. | |||||||
| Steps To Reproduce | Simply remove a table and a dependant view from your database xml files, and perform a ant update.database | |||||||
| Proposed Solution | The solution will be to delete views before deleting tables, so that this problem doesn't happen. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0008731) svnbot (reporter) 2008-08-25 17:30 |
Repository: dbsourcemanager Revision: 106 Author: marvintm Date: 2008-08-25 17:30:58 +0200 (Mon, 25 Aug 2008) Fixed bug 0004706. Now views will be dropped before tables. --- U branches/r0.8x/src/org/apache/ddlutils/platform/SqlBuilder.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=106&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-08-25 17:29 | marvintm | New Issue | |
| 2008-08-25 17:29 | marvintm | Assigned To | => marvintm |
| 2008-08-25 17:30 | svnbot | Checkin | |
| 2008-08-25 17:30 | svnbot | Note Added: 0008731 | |
| 2008-08-25 17:30 | svnbot | Status | new => resolved |
| 2008-08-25 17:30 | svnbot | Resolution | open => fixed |
| 2008-08-25 17:30 | svnbot | svn_revision | => 106 |
| 2008-12-15 19:05 | psarobe | Status | resolved => closed |
| 2008-12-18 12:38 | jpabloae | Sticky Issue | No => Yes |
| 2008-12-18 12:39 | jpabloae | Sticky Issue | Yes => No |
| 2008-12-18 12:39 | jpabloae | Tag Attached: dbsm_migrate | |
| 2008-12-18 12:41 | jpabloae | Project | @4@ => Openbravo ERP |
| 2008-12-18 12:42 | jpabloae | Category | => Y. DBSourceManager |
| 2009-03-18 11:02 | anonymous | sf_bug_id | 0 => 2691341 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |