Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0019057 | Openbravo ERP | Y. DBSourceManager | public | 2011-11-14 08:22 | 2011-11-14 16:44 |
| Reporter | neil_smith | ||||
| Assigned To | marvintm | ||||
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | 3.0MP4.1 | ||||
| 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 | 0019057: DO INSTEAD on view | ||||
| Description | When working with views, it is not possible to delete/update/insert on them (in PostgreSQL). There is a way to bypass this problem by creating a 'DO INSTEAD' rule on the view such as reported in the postgreSQL documentation CREATE RULE name AS ON event TO object [ WHERE condition ] DO [ INSTEAD ] [ action | NOTHING ] in my case, 'name' is the name of my rule, 'event' is DELETE, 'object' is my view and the action is 'DO INSTEAD DELETE FROM ...' When the context is exported (ant export.database), this rule is not exported. This causes a big problem because after each update, the rule is lost and I have to recreate it manually. | ||||
| Steps To Reproduce | 1. Create the rule 2. ant export.database 3. the rule is deleted from in the database | ||||
| Proposed Solution | The rules have to be saved with the context (export.database) | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2011-11-14 08:22 | neil_smith | New Issue | |||
| 2011-11-14 08:22 | neil_smith | Assigned To | => alostale | ||
| 2011-11-14 08:22 | neil_smith | Modules | => Core | ||
| 2011-11-14 12:01 | shuehner | Category | 00. Application dictionary => Y. DBSourceManager | ||
| 2011-11-14 12:01 | shuehner | Type | defect => feature request | ||
| 2011-11-14 16:44 | alostale | Assigned To | alostale => marvintm | ||
| There are no notes attached to this issue. |