Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016334 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2011-03-01 10:18 | 2011-03-17 00:00 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 437a06f270a0 | ||||
| Projection | none | ETA | none | Target Version | 3.0RC5 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 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 | 0016334: PG: Not possible to change function signature | |||||||
| Description | In a PG DB. Having a module installed with a PL function, it is not possible to update this module if it changes that function's signature. This is the error got in update.database process: SQL Command failed with: ERROR: cannot change return type of existing function | |||||||
| Proposed Solution | Old function should be dropped before trying to create new one. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0034951) hgbot (developer) 2011-03-16 18:17 |
Repository: erp/devel/dbsm-main Changeset: ed4117dbc2a9eb9fce8c80b03deda2040aae51d4 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Mar 16 18:12:39 2011 +0100 URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/ed4117dbc2a9eb9fce8c80b03deda2040aae51d4 [^] Fixed issue 16334. Views will be dropped before functions are dropped --- M src/org/apache/ddlutils/platform/SqlBuilder.java --- |
|
(0034954) hgbot (developer) 2011-03-16 18:17 |
Repository: erp/devel/pi Changeset: 8f593389661dc9a2724ad64d3e25594165373c2d Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Mar 16 18:15:40 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/8f593389661dc9a2724ad64d3e25594165373c2d [^] Fixed issue 16331. Fixed issue 16329. Fixed issue 16334. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0034959) hgbot (developer) 2011-03-16 18:19 |
Repository: erp/stable/2.50 Changeset: 437a06f270a020cbcdcdd1a5b93c0ae2f52ce487 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Mar 16 18:18:33 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/437a06f270a020cbcdcdd1a5b93c0ae2f52ce487 [^] Fixed issue 16331. Fixed issue 16329. Fixed issue 16334. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0034961) marvintm (viewer) 2011-03-16 18:21 |
The initial change was: https://code.openbravo.com/erp/devel/dbsm-main/rev/ee9961cbd2e3 [^] This change had problems because functions were dropped before views. |
|
(0034962) shuehner (administrator) 2011-03-16 18:40 |
Tested with update from 2.50MP0 on postgres & oracle to latest main (rev: 42cb4c157d3e). and also changing a function header of an existing function to test that the new drop+create logic fixes that issue. For the logging change to only report forced command if they still fail after the forced command loop partially tested in the 2.50 -> main/tip update. And the fails always tested via creating a broken view definition. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-03-16 15:45 | marvintm | Type | defect => backport |
| 2011-03-16 15:45 | marvintm | fix_in_branch | => 2.50 |
| 2011-03-16 18:10 | marvintm | Type | backport => defect |
| 2011-03-16 18:10 | marvintm | Target Version | => 3.0RC5 |
| 2011-03-16 18:10 | marvintm | fix_in_branch | 2.50 => |
| 2011-03-16 18:17 | hgbot | Checkin | |
| 2011-03-16 18:17 | hgbot | Note Added: 0034951 | |
| 2011-03-16 18:17 | hgbot | Status | scheduled => resolved |
| 2011-03-16 18:17 | hgbot | Resolution | open => fixed |
| 2011-03-16 18:17 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/1e390dd8d3994be8f82913ea015aeab79a3c8aad [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/ed4117dbc2a9eb9fce8c80b03deda2040aae51d4 [^] |
| 2011-03-16 18:17 | hgbot | Checkin | |
| 2011-03-16 18:17 | hgbot | Note Added: 0034954 | |
| 2011-03-16 18:17 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/dbsm-main/rev/ed4117dbc2a9eb9fce8c80b03deda2040aae51d4 [^] => http://code.openbravo.com/erp/devel/pi/rev/8f593389661dc9a2724ad64d3e25594165373c2d [^] |
| 2011-03-16 18:19 | hgbot | Checkin | |
| 2011-03-16 18:19 | hgbot | Note Added: 0034959 | |
| 2011-03-16 18:19 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/8f593389661dc9a2724ad64d3e25594165373c2d [^] => http://code.openbravo.com/erp/stable/2.50/rev/437a06f270a020cbcdcdd1a5b93c0ae2f52ce487 [^] |
| 2011-03-16 18:21 | marvintm | Note Added: 0034961 | |
| 2011-03-16 18:40 | shuehner | Note Added: 0034962 | |
| 2011-03-16 18:40 | shuehner | Status | resolved => closed |
| 2011-03-17 00:00 | anonymous | sf_bug_id | 0 => 3217703 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |