Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021985Openbravo ERPY. DBSourceManagerpublic2012-10-18 07:502012-10-30 12:40
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP17 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021985: Views are exported differently in PostgreSQL 9.2
DescriptionViews are exported differently in PostgreSQL 9.2. This happens because there has been a change in the prettyPrinting function in Postgre. DBSourceManager should handle this.
Steps To ReproduceExport views in PostgreSQL 9.2. Notice that they are exported differently.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0024102 closed shuehner Views are exported differently in PostgreSQL 9.2 - part2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-18 07:50marvintmNew Issue
2012-10-18 07:50marvintmAssigned To => marvintm
2012-10-18 07:50marvintmModules => Core
2012-10-18 07:52hgbotCheckin
2012-10-18 07:52hgbotNote Added: 0053438
2012-10-18 07:52hgbotStatusnew => resolved
2012-10-18 07:52hgbotResolutionopen => fixed
2012-10-18 07:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/72b6543e9b3f70eeb2fed1630134f44c3fadb9be [^]
2012-10-18 07:55hgbotCheckin
2012-10-18 07:55hgbotNote Added: 0053439
2012-10-18 07:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/dbsm-main/rev/72b6543e9b3f70eeb2fed1630134f44c3fadb9be [^] => http://code.openbravo.com/erp/devel/pi/rev/b4f0be311a5443d453aa4a02d775046cc308c707 [^]
2012-10-22 13:27hudsonbotCheckin
2012-10-22 13:27hudsonbotNote Added: 0053516
2012-10-30 10:14alostaleReview Assigned To => AugustoMauch
2012-10-30 12:40AugustoMauchNote Added: 0053808
2012-10-30 12:40AugustoMauchStatusresolved => closed
2012-10-30 12:40AugustoMauchFixed in Version => 3.0MP17
2013-06-17 16:40shuehnerRelationship addedrelated to 0024102

Notes
(0053438)
hgbot   
2012-10-18 07:52   
Repository: erp/devel/dbsm-main
Changeset: 72b6543e9b3f70eeb2fed1630134f44c3fadb9be
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Oct 18 07:52:11 2012 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/72b6543e9b3f70eeb2fed1630134f44c3fadb9be [^]

Fixed issue 21985. Views will now be exported according to PostgreSQL 9.2 format.

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSQLStandarization.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0053439)
hgbot   
2012-10-18 07:55   
Repository: erp/devel/pi
Changeset: b4f0be311a5443d453aa4a02d775046cc308c707
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Oct 18 07:54:20 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b4f0be311a5443d453aa4a02d775046cc308c707 [^]

Fixed issue 21985. Views will now be exported according to PostgreSQL 9.2 format.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_ACCT_V.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRX_FULL_ACCT_V.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_REC_DETAIL_V.xml
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/views/AD_AUDIT_TRAIL_V.xml
M src-db/database/model/views/AD_ORGMODULE_V.xml
M src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
M src-db/database/model/views/AD_REF_LIST_V.xml
M src-db/database/model/views/AD_TABLE_POST_V.xml
M src-db/database/model/views/C_DEBT_PAYMENT_CANCEL.xml
M src-db/database/model/views/C_DEBT_PAYMENT_GENERATE.xml
M src-db/database/model/views/C_DEBT_PAYMENT_V.xml
M src-db/database/model/views/C_INVOICELINE_V.xml
M src-db/database/model/views/C_INVOICELINE_V2.xml
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
M src-db/database/model/views/C_INVOICE_V.xml
M src-db/database/model/views/C_INVOICE_V2.xml
M src-db/database/model/views/C_ORDER_LINETAX_VT.xml
M src-db/database/model/views/C_PERIODCONTROL_V.xml
M src-db/database/model/views/C_PROJECTPROPOSAL_V.xml
M src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml
M src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_EXEC_HISTORY_V.xml
M src-db/database/model/views/FIN_PAYMENT_PROP_DETAIL_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml
M src-db/database/model/views/FIN_RECONCILIATIONLINE_V.xml
M src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
M src-db/database/model/views/M_COSTING_RULE_PRODUCT_V.xml
M src-db/database/model/views/M_INOUT_CANDIDATE_V.xml
M src-db/database/model/views/M_PRODUCT_PRICE_WAREHOUSE_V.xml
M src-db/database/model/views/M_PRODUCT_STOCK_V.xml
M src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
M src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
M src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml
M src-db/database/model/views/M_TRANSACTION_V.xml
M src-db/database/model/views/S_TIMEEXPENSELINE_V.xml
---
(0053516)
hudsonbot   
2012-10-22 13:27   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/483f2e6dc1af [^]

Maturity status: Test
(0053808)
AugustoMauch   
2012-10-30 12:40   
Code reviewed and verified in pi@2c82168e2836