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 | |||||||
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 | 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 ] | |
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 (developer) 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. |
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 |
Copyright © 2000 - 2009 MantisBT Group |