Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016334
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2011-03-01 10:182011-03-17 00:00
ReporteralostaleView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision437a06f270a0
ProjectionnoneETAnoneTarget Version3.0RC5
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016334: PG: Not possible to change function signature

DescriptionIn 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 SolutionOld function should be dropped before trying to create new one.
TagsNo 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
Powered by Mantis Bugtracker