Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005370Openbravo ERP01. General setuppublic2008-10-01 19:582008-10-06 09:39
Reporterplujan 
Assigned Tocromero 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product Version2.40 
Target VersionFixed in Version2.40 
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
Summary0005370: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing
DescriptionI installed 2.40 with sample data. If I try to delete BigBazaar client (by executing a Delete Client process), after execution some FK constraints are missing and data with no valid FK is on affected tables.
Steps To Reproduce1. Install OpenbravoERP 2.40 with sample data on a PostgreSQL computer.
2. Go to Pgadmin and check the ad_windowaccess table, ad_windowaccess_id_role FK constraint is present.
3. Enter as Openbravo (system administrator role)
4. Go General Setup > Client > Delete Client
5. Delete Account Test client and BigBazaar client
6. Go to Pgadmin and check the ad_windowaccess table, ad_windowaccess_id_role FK constraint is missing.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0005368 closed cromero On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-01 19:58cromeroNew Issue
2008-10-01 19:58cromeroAssigned To => cromero
2008-10-01 19:58cromeroStatusnew => scheduled
2008-10-01 20:51svnbotCheckin
2008-10-01 20:51svnbotNote Added: 0009307
2008-10-01 20:51svnbotStatusscheduled => resolved
2008-10-01 20:51svnbotResolutionopen => fixed
2008-10-01 20:51svnbotsvn_revision => 8148
2008-10-06 09:39plujanRegression testing => No
2008-10-06 09:39plujanStatusresolved => closed
2008-10-06 09:39plujanFixed in Version => 2.40

Notes
(0009307)
svnbot   
2008-10-01 20:51   
Repository: openbravo
Revision: 8148
Author: cromeroherrero
Date: 2008-10-01 20:51:13 +0200 (Wed, 01 Oct 2008)

Fixed bug 5370: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing

---
U branches/r2.40-installer/src-db/database/model/postscript-PostgreSql.sql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8148&sc=1 [^]