Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015768 | Openbravo ERP | 02. Master data management | public | 2011-01-25 11:59 | 2015-05-14 11:01 |
|
| Reporter | dalsasua | |
| Assigned To | dmiguelez | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | invalid | |
| Platform | | OS | 20 | OS Version | Ubuntu 10.10 |
| Product Version | 2.50 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015768: An organization cannot be deleted in postgresql |
| Description | In 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 Reproduce | Create 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 Solution | Change the code in the trigger that deletes the ad_treenode entry with an on cascade for the foreign key? Must be studied... |
| Additional Information | |
| Tags | VMA-Reviewed |
| Relationships | | has duplicate | feature request | 0007599 | | acknowledged | rmorley | New process: Delete Organization |
|
| Attached Files |  ScreenShot.png (161,869) 2011-01-25 12:01
https://issues.openbravo.com/file_download.php?file_id=3545&type=bug
|
|
| 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 |