Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047767Openbravo ERPA. Platformpublic2021-09-28 11:332023-05-23 17:32
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
Summary0047767: support PostgreSQL 15
DescriptionIssue to track any changes required to eventually add support for PostgreSQL 15
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0046376 closed shuehner support PostgreSQL 14 
related to feature request 0052538 new Triage Platform Base support PostgreSQL 16 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-09-28 11:33shuehnerNew Issue
2021-09-28 11:33shuehnerAssigned To => platform
2021-09-28 11:33shuehnerModules => Core
2021-09-28 11:33shuehnerTriggers an Emergency Pack => No
2021-09-28 11:33shuehnerIssue generated from0046376
2021-09-28 11:33shuehnerRelationship addedrelated to 0046376
2021-09-28 11:46shuehnerNote Added: 0132037
2022-02-01 08:07alostaleAssigned Toplatform => Triage Platform Base
2022-05-26 15:41shuehnerNote Edited: 0132037bug_revision_view_page.php?bugnote_id=0132037#r24159
2022-06-02 17:39shuehnerNote Added: 0137997
2023-05-23 17:32shuehnerIssue cloned0052538
2023-05-23 17:32shuehnerRelationship addedrelated to 0052538
2024-11-04 11:16shuehnerNote Edited: 0137997bug_revision_view_page.php?bugnote_id=0137997#r28701

Notes
(0132037)
shuehner   
2021-09-28 11:46   
(edited on: 2022-05-26 15:41)
Status as of 2021-09-28 (using Debian 15~~devel~20210928.0430-1~240.git7d1aa6b.pgdg+1))

No problems found or work do. Tested (with backoffice repo only)
- install.source
- update.database
- export.database
- export.config.script
- dbsm test suite
(0137997)
shuehner   
2022-06-02 17:39   
(edited on: 2024-11-04 11:16)
Status as of 2022-06-02 (15~beta1-1)

Install.source fails with: syntax error at or near "IS" at character 302
2 errors located in 2* instr functions in prescript-PostgreSQL.sql
Cause is parameter named "String" which was made reserved work.

But already discussed as regression on -hackers and fix pushed to postgresql.git
https://www.postgresql.org/message-id/3661437.1653855582%40sss.pgh.pa.us [^]

Pending verification when beta2 is out

=> Got fixed (on postgres side) before the final release.