Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000469 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-05-29 10:01 | 2009-03-18 11:02 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 74 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.5.0_15 | |||
| OS Version | Gentoo - 2.6.24 | Database version | 8.3.1 | Ant version | 1.7.0 | |||
| 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 | 0000469: Constraints consistency not checked in update.database with PostgreSQL | |||||||
| Description | Currently the "ant update.database" task does not maintain the sampledata consistency. So that if an ID is deleted in sourcedata and there are records in sampledata referencing that ID, it doesn't raise an error and there are inconsistent records in the database. In oracle it raises an error, see 0000468. Ideally, it should give an error when there's a invalid constraint. | |||||||
| Steps To Reproduce | 1. Delete an AD_PROCESS_ID in AD_PROCESS.xml in sourcedata. 2. Make sure there's a record in sampledata/AD_PROCESS_ACCESS.xml referencing that deleted AD_PROCESS_ID. 3. Run "ant update.database". It doesn't fail, and currently it should. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0007741) svnbot (reporter) 2008-06-16 15:36 |
Repository: dbsourcemanager Revision: 74 Author: marvintm Date: 2008-06-16 15:36:00 +0200 (Mon, 16 Jun 2008) Fixed bug 0000469 Now error messages will be shown in PostgreSQL if XML data prevents a constraint from being activated (specifically, if a row contains a reference to another row which doesn't exist ie. a foreign key is invalid). --- U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlBuilder.java U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=74&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-29 10:01 | jpabloae | New Issue | |
| 2008-05-29 10:01 | jpabloae | Relationship added | related to 0000468 |
| 2008-06-16 15:36 | svnbot | Checkin | |
| 2008-06-16 15:36 | svnbot | Note Added: 0007741 | |
| 2008-06-16 15:36 | svnbot | Status | new => resolved |
| 2008-06-16 15:36 | svnbot | Resolution | open => fixed |
| 2008-06-16 15:36 | svnbot | svn_revision | => 74 |
| 2008-11-26 13:37 | psarobe | Status | resolved => closed |
| 2008-11-28 12:54 | jpabloae | Assigned To | => marvintm |
| 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:41 | jpabloae | Category | => Y. DBSourceManager |
| 2009-03-18 11:02 | anonymous | sf_bug_id | 0 => 2691318 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |