Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008857Openbravo ERPY. DBSourceManagerpublic2009-04-30 17:372009-05-10 00:00
Reportermarvintm 
Assigned Tomarvintm 
PriorityurgentSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008857: PL/SQL functions and triggers fail on PostgreSQL if they belong to a module applied through the module console
DescriptionPL/SQL functions and triggers fail on PostgreSQL if they belong to a module, and the module is applied through the module console. The update.database task inserts them correctly, but the update.database.mod one doesn't (they are inserted without being translated, and thus fail in PostgreSQL, although not in Oracle).
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP1, Modularity
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-30 17:37marvintmNew Issue
2009-04-30 17:37marvintmAssigned To => marvintm
2009-04-30 17:37marvintmOBNetwork customer => No
2009-04-30 17:37marvintmRegression testing => No
2009-04-30 17:37marvintmTag Attached: 250MP1
2009-04-30 17:37marvintmTag Attached: Modularity
2009-04-30 18:28hgbotCheckin
2009-04-30 18:28hgbotNote Added: 0015971
2009-04-30 18:28hgbotStatusnew => resolved
2009-04-30 18:28hgbotResolutionopen => fixed
2009-04-30 18:30hgbotCheckin
2009-04-30 18:30hgbotNote Added: 0015973
2009-04-30 18:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a6d86676dfd2118f8e2053536918ad059efed6f1 [^]
2009-05-09 18:55psarobeStatusresolved => closed
2009-05-09 18:55psarobeNote Added: 0016201
2009-05-10 00:00anonymoussf_bug_id0 => 2789550

Notes
(0015971)
hgbot   
2009-04-30 18:28   
Repository: dbsourcemanager
Revision: 308
Author: marvintm
Date: 2009-04-30 18:28:20 +0200 (Thu, 30 Apr 2009)

Fixed issue 8857. Now functions will be completely translated in PostgreSQL even if they are being inserted as part of an update.database.mod task.

---
U trunk/src/org/apache/ddlutils/Platform.java
U trunk/src/org/apache/ddlutils/platform/PlatformImplBase.java
U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseDataMod.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=308&sc=1 [^]
(0015973)
hgbot   
2009-04-30 18:30   
Repository: erp/devel/pi
Changeset: a6d86676dfd2118f8e2053536918ad059efed6f1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Apr 30 18:29:49 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a6d86676dfd2118f8e2053536918ad059efed6f1 [^]

Fixed issue 8857. Now functions will be completely translated in PostgreSQL even if they are being inserted as part of an update.database.mod task.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0016201)
psarobe   
2009-05-09 18:55   
I have installed Hello world process that has a stored procedure in postgres and works fine