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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015768
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2011-01-25 11:592015-05-14 11:01
ReporterdalsasuaView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutioninvalidFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionad7168af39fc
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_21
OS VersionUbuntu 10.10Database version8.4.6Ant version1.8.0
Product Version2.50SCM revisiond1e872fa524f 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015768: An organization cannot be deleted in postgresql

DescriptionIn Oracle, the trigger is executed before checking the constraints, so when deleting an organization, trigger code deletes the ad_treenode entry for that organization in the organizational tree (actually, was the same trigger the one that created it when creating the organization record). After that, the foreign key costraint on ADTreenode.AdOrgId column is checked. As postgresql does the other way arround (checks the constraint before executing the trigger), an error is shown (see attachment)
Steps To ReproduceCreate a new client
Logged with new client, create a new organization
Logout and login to be able to see the new organization
Try to delete it
Check that the error shown in the attachment is shown
Proposed SolutionChange the code in the trigger that deletes the ad_treenode entry with an on cascade for the foreign key? Must be studied...
TagsVMA-Reviewed
Attached Filespng file icon ScreenShot.png [^] (161,869 bytes) 2011-01-25 12:01

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate feature request 0007599 acknowledgedrmorley New process: Delete Organization 

-  Notes
(0058379)
hgbot (developer)
2013-04-30 20:06

 Repository: erp/devel/pi
Changeset: ad7168af39fcc9888e44638c2a4844fcd19a896e
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Apr 29 13:47:02 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ad7168af39fcc9888e44638c2a4844fcd19a896e [^]

Fixes Issue 15768. Executes trigger before deleting record.

---
M src-db/database/model/tables/AD_IMAGE.xml
M src-db/database/model/triggers/AD_ORG_TRG.xml
A src-db/database/model/triggers/AD_ORG_BEFORE_TRG.xml
---
(0058439)
hudsonbot (developer)
2013-05-02 19:03

 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/b67b46460127 [^]

Maturity status: Test
(0077433)
plujan (manager)
2015-05-14 11:01

 Deleting an organization requires a more complex procedure than regular deletions, similar to what happen with Delete Client. A Feature Request already exist about this.

- Issue History
Date Modified Username Field Change
2011-01-25 11:59 dalsasua New Issue
2011-01-25 11:59 dalsasua Assigned To => adrianromero
2011-01-25 11:59 dalsasua Modules => Core
2011-01-25 12:01 dalsasua File Added: ScreenShot.png
2011-06-03 10:58 dalsasua Assigned To adrianromero => dalsasua
2011-07-20 18:16 dalsasua Assigned To dalsasua => jonalegriaesarte
2012-02-15 19:05 iciordia Assigned To jonalegriaesarte => vmromanos
2012-02-16 15:55 vmromanos Tag Attached: VMA-Reviewed
2012-05-10 12:13 gorka_gil Assigned To vmromanos => mirurita
2012-05-15 09:34 Sandrahuguet Assigned To mirurita => Sandrahuguet
2012-05-15 09:36 Sandrahuguet Status new => scheduled
2012-05-15 09:36 Sandrahuguet fix_in_branch => pi
2013-04-30 20:06 hgbot Checkin
2013-04-30 20:06 hgbot Note Added: 0058379
2013-04-30 20:06 hgbot Status scheduled => resolved
2013-04-30 20:06 hgbot Resolution open => fixed
2013-04-30 20:06 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ad7168af39fcc9888e44638c2a4844fcd19a896e [^]
2013-05-02 09:45 dmiguelez Assigned To Sandrahuguet => dmiguelez
2013-05-02 09:45 dmiguelez Status resolved => new
2013-05-02 09:45 dmiguelez Resolution fixed => open
2013-05-02 19:03 hudsonbot Checkin
2013-05-02 19:03 hudsonbot Note Added: 0058439
2015-05-14 11:01 plujan Note Added: 0077433
2015-05-14 11:01 plujan Status new => closed
2015-05-14 11:01 plujan Resolution open => invalid
2015-05-14 11:01 plujan Relationship added has duplicate 0007599

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker