Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016429Openbravo ERPY. DBSourceManagerpublic2011-03-22 16:552011-06-10 13:19
Reportermarvintm 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0016429: Local changes detected when a database is exported with pg_dump and imported again
DescriptionWhen a database is exported and imported again with pg_dump/pg_restore, the ad_db_modified function finds changes (which do not exist) in the database structure.

The problem happens because PostsgreSQL adds some characters ('()' and '[]') to the database views and checks. Then, the calculated mp5 is different, and therefore, changes are detected.
Steps To ReproduceInstall the rc5 virtual appliance, and verify that when you try to install a module, pack, or Core obx, changes are detected in the database.
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
related to defect 0016422 closed marvintm Local changes detected when a database is exported with pg_dump and imported again 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-22 16:55marvintmNew Issue
2011-03-22 16:55marvintmAssigned To => marvintm
2011-03-22 16:55marvintmModules => Core
2011-03-22 16:55marvintmOBNetwork customer => No
2011-03-22 17:00hgbotCheckin
2011-03-22 17:00hgbotNote Added: 0035160
2011-03-22 17:00hgbotStatusnew => resolved
2011-03-22 17:00hgbotResolutionopen => fixed
2011-03-22 17:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/1087f5b61e3b92c585cda33c4bf1fc76bd33a00d [^]
2011-05-24 10:49dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed
2011-06-10 13:19plujanRelationship addedrelated to 0016422

Notes
(0035160)
hgbot   
2011-03-22 17:00   
Repository: erp/stable/2.50
Changeset: 1087f5b61e3b92c585cda33c4bf1fc76bd33a00d
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Mar 22 16:57:16 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/1087f5b61e3b92c585cda33c4bf1fc76bd33a00d [^]

Fixed issue 16429. dump/restore will no longer cause ad_db_modified to detect non-existant db structure changes

---
M src-db/database/model/prescript-PostgreSql.sql
---