Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002534Openbravo ERPZ. Otherspublic2008-01-18 20:512008-06-12 09:43
Reporteruser71 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
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
Summary0002534: [R2.35-MP1] DBA_RECOMPILE does not compile in postgres
DescriptionThis line in database/model/functions/DBA_RECOMPILE.xml:

    TYPE invalid_tab IS TABLE OF Cur_Invalids%ROWTYPE INDEX BY BINARY_INTEGER;

does not work for postgres due to TYPE has no sense for pg. ddlutils knows it and prepends it with --, but then, the next variable of type invalid_tab has no type defined.

DBA_AFTERIMPORT also will not work because it uses DBA_RECOMPILE.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003607 closed marvintm [R2.35-MP1] DBA_RECOMPILE does not compile in po 
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0006123)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1875004 [^]
(0003066)
cromero   
2008-01-21 18:23   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500614
Originator: NO

These functions are not useful for PostgreSQL distribution and in fact they are not used.
The correct way will be that they were skipped in the create/update database process for POstgreSQL.

Carlos Romero
Openbravo Team
(0003067)
pjuvara   
2008-03-13 18:51   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1871571
Originator: NO

>> This are known problems. They have zero repercussions in the operation
>> of Openbravo.
>>
>> The first problem is related to a function that should be inserted in
>> Oracle, but that it is not needed in PostgreSQL.
>>
>> The problem with AD_DEVELOPER is that it was not previously created, and
>> therefore it can't be deleted. That is again a non-issue. The
>> C_INVOICELINE_V view is later correctly created.
>>
>> This problems are partially corrected in the trunk, but the important
>> thing to know is that the database is created correctly, and that there
>> will be no problems, even if this messages appear.
(0003068)
adrianromero   
2008-03-14 09:49   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=986995
Originator: NO

This procedure may be removed of the Openbravo ERP model and move it to the pre or post script only for Oracle.

Adrián.
(0003069)
marvintm   
2008-05-28 16:48   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1952914
Originator: NO

Sorry but this bug is duplicated

Please next time before reporting a new one bug try to find out if it has been already reported.

Thank you
(0003070)
marvintm   
2008-05-28 16:48   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1952914
Originator: NO

This was fixed several months ago by moving Oracle-specific procedures to the Oracle postscript.