Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0042080 | Openbravo ERP | A. Platform | public | 2019-10-22 09:48 | 2022-02-01 07:24 |
| Reporter | AugustoMauch | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| 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 | 0042080: Views are not being taken into account in the ad_db_modified function in PostgreSQL | ||||
| Description | The ad_db_modified function is used to detect if there are local changes in the database before updating it. It checks several database objects, like tables, functions, triggers, etc. The problem is that in the postgresql version, views are not being taken into account. So, if someone creates a new view in the database, that view will be dropped the next time update.database is run, because the local changes will not be detected. | ||||
| Steps To Reproduce | In an Openbravo environment that uses postgresql: - Execute update.database to make sure there are no local changes to begin with. - Add a new view, for instance: create view c_order_v as select * from c_order; ALTER TABLE public.c_order_v OWNER TO tad; - Execute update.database again. It should fail because there are local changes in the database, but it does not detect them. - Check that the view created in step 2 no longer exists: select * from pg_class where relname ilike 'c_order_v'; (or \d c_order_v in psql) | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2019-10-22 09:48 | AugustoMauch | New Issue | |||
| 2019-10-22 09:48 | AugustoMauch | Assigned To | => platform | ||
| 2019-10-22 09:48 | AugustoMauch | Modules | => Core | ||
| 2019-10-22 09:48 | AugustoMauch | Triggers an Emergency Pack | => No | ||
| 2022-02-01 07:24 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |