Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052538Openbravo ERPA. Platformpublic2023-05-23 17:322023-10-18 11:26
Reportershuehner 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052538: support PostgreSQL 16
DescriptionIssue to track any changes required to eventually add support for PostgreSQL 16
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0047767 new Triage Platform Base support PostgreSQL 15 
depends on defect 0052980 closed Triage Omni WMS database view m_product_warehouse_qtys_v is unused and should be removed 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-05-23 17:32shuehnerNew Issue
2023-05-23 17:32shuehnerAssigned To => Triage Platform Base
2023-05-23 17:32shuehnerModules => Core
2023-05-23 17:32shuehnerTriggers an Emergency Pack => No
2023-05-23 17:32shuehnerIssue generated from0047767
2023-05-23 17:32shuehnerRelationship addedrelated to 0047767
2023-05-23 17:38shuehnerNote Added: 0150157
2023-07-12 13:52hgbotNote Added: 0152387
2023-07-12 13:58hgbotNote Added: 0152388
2023-10-09 11:00hgbotNote Added: 0155664
2023-10-09 11:55hgbotNote Added: 0155674
2023-10-09 12:01aferrazNote Deleted: 0155664
2023-10-09 12:01aferrazNote Deleted: 0155674
2023-10-18 11:26shuehnerRelationship addeddepends on 0052980

Notes
(0150157)
shuehner   
2023-05-23 17:38   
Status as of 2023-05-23 (using Debian 16~~devel-1.pgdg120+~20230522.2259.ge0b82fc)

No problems found or work do. Tested (with backoffice repo only)
- install.source
- update.database
- export.config.script

Problems found with
- export.database shows differences in 6 views
  apparently table alias gets removed on export at least in some cases

Untested:
- dbsm testsuite
(0152387)
hgbot   
2023-07-12 13:52   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/939 [^]
(0152388)
hgbot   
2023-07-12 13:58   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/152 [^]