Tuesday, April 2, 2024
1 change · saas-17.2
Resolved issues and error corrections
This change removes a duplicate Inventory page path that could cause errors when users refreshed the page or shared a link. It also adds an extra check to prevent similar duplicate paths from being created in the future, improving navigation reliability.
Original PR description
Since [1], a duplicate path `inventory` was introduced, this leads to errors when reloading the page, or when a URL is shared. Normally, duplicated path should be impossible due to the unique SQL constraint, added in [2]. But, the tables ir_act_window, ir_act_report_xml, ir_act_url, ir_act_server and ir_act_client inherit from table ir_actions (see base_data.sql). And a big limitation of the postgresql inheritance feature is that unique indexes only apply to the single tables, and not across all the tables, for more information see [3]. This commit, removes the duplicated path, and add a python api constraint, to check the uniqueness of the path. [1] https://github.com/odoo/odoo/commit/814d2dc6ac5c06403ae5d2133d572a6b01edc1c0 [2] https://github.com/odoo/odoo/commit/c63d14a0485a553b74a8457aee158384e9ae6d3f [3] https://www.postgresql.org/docs/14/ddl-inherit.html#DDL-INHERIT-CAVEATS