Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004705 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2008-08-25 16:29 | 2008-12-02 13:02 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | jpabloae | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 6536 | ||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004705: OnCreateDefault command doesn't work in PostgreSQL | |||||||
| Description | When the update.customized.database process is executed while trying to upgrade a customized r2.35 mp5 database to a r2.4 database, there are several errors related to the OnCreateDefault attribute of several tables. Specifically, the problem is related to the "SELECT 'x' FROM DUAL" syntax used there. Those statements should be replaced by a simple 'x', to make them compatible both with Oracle and PostgreSQL. | |||||||
| Steps To Reproduce | Just use the ant update.customized.database process in an MP5 database, with an originalDatabase folder containing an MP5 database, and a database folder containing the 2.40 standard xml files. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008729) svnbot (viewer) 2008-08-25 16:31 |
Repository: openbravo Revision: 6536 Author: jpabloae Date: 2008-08-25 16:31:51 +0200 (Mon, 25 Aug 2008) Fixes issue 4705: OnCreateDefault command doesn't work in PostgreSQL --- U trunk/src-db/database/model/tables/C_BANKACCOUNT.xml U trunk/src-db/database/model/tables/C_BP_BANKACCOUNT.xml U trunk/src-db/database/model/tables/C_GLITEM.xml U trunk/src-db/database/model/tables/C_PROJECT.xml U trunk/src-db/database/model/tables/C_PROJECTTASK.xml U trunk/src-db/database/model/tables/C_TAX.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=6536&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-08-25 16:29 | jpabloae | New Issue | |
| 2008-08-25 16:29 | jpabloae | Assigned To | => jpabloae |
| 2008-08-25 16:29 | jpabloae | OBNetwork customer | => No |
| 2008-08-25 16:29 | jpabloae | Regression testing | => No |
| 2008-08-25 16:29 | jpabloae | Issue generated from | 0004704 |
| 2008-08-25 16:29 | jpabloae | Relationship added | related to 0004704 |
| 2008-08-25 16:31 | svnbot | Checkin | |
| 2008-08-25 16:31 | svnbot | Note Added: 0008729 | |
| 2008-08-25 16:31 | svnbot | Status | new => resolved |
| 2008-08-25 16:31 | svnbot | Resolution | open => fixed |
| 2008-08-25 16:31 | svnbot | svn_revision | => 6536 |
| 2008-08-25 16:32 | jpabloae | Target Version | 2.40 => trunk |
| 2008-09-04 16:22 | psarobe | Target Version | trunk => 2.40 |
| 2008-11-25 23:20 | psarobe | Status | resolved => closed |
| 2008-12-02 13:02 | jaimetorre | sf_bug_id | 0 => 2377077 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |