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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016429
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] Y. DBSourceManagermajorhave not tried2011-03-22 16:552011-06-10 13:19
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1087f5b61e3b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava 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

0016429: 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.
TagsclosingMay2011
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0016422 closedmarvintm Local changes detected when a database is exported with pg_dump and imported again 

-  Notes
(0035160)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2011-03-22 16:55 marvintm New Issue
2011-03-22 16:55 marvintm Assigned To => marvintm
2011-03-22 16:55 marvintm Modules => Core
2011-03-22 17:00 hgbot Checkin
2011-03-22 17:00 hgbot Note Added: 0035160
2011-03-22 17:00 hgbot Status new => resolved
2011-03-22 17:00 hgbot Resolution open => fixed
2011-03-22 17:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/1087f5b61e3b92c585cda33c4bf1fc76bd33a00d [^]
2011-05-24 10:49 dalsasua Tag Attached: closingMay2011
2011-05-24 10:55 dalsasua Status resolved => closed
2011-06-10 13:19 plujan Relationship added related to 0016422


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker