Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Make PostgreSQL Support Native

Description

Master ticket to track the effort to make the PostgreSQL support completely native in iDempiere, i.e run without any conversion from Oracle syntax.

Environment

None

Attachments

1

causes

is blocked by

relates to

Activity

Show:

Carlos RuizJuly 31, 2020 at 11:39 AM

Another finding in

Carlos RuizJuly 30, 2020 at 1:07 PM

Found new issue on triage today ->

Carlos RuizMarch 15, 2020 at 9:06 AM

Hi , replaced the three occurrences of TO_NCHAR in core
https://github.com/idempiere/idempiere/commit/4e6794

Heng Sin LowMarch 15, 2020 at 2:30 AM

Hi , base on the discussions at IDEMPIERE-4178, I think instead of using to_nchar, replacing coalesce with nvl should work for both Oracle and PostgreSQL (i.e replace COALESCE(s.Name,TO_NCHAR('-')) with NVL(s.Name,'-')).

Diego RuizMarch 12, 2020 at 11:28 AM

Thank you ,

I’ve created reporting the found bug.

Fixed

Details

Assignee

Reporter

Components

Priority

Created February 18, 2020 at 1:04 AM
Updated September 19, 2020 at 9:40 AM
Resolved July 2, 2020 at 5:58 PM