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

Activity

Show:
Diego Ruiz
March 12, 2020, 11:28 AM

Thank you ,

I’ve created reporting the found bug.

Heng Sin Low
March 15, 2020, 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,'-')).

Carlos Ruiz
March 15, 2020, 9:06 AM

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

Carlos Ruiz
July 30, 2020, 1:07 PM

Found new issue on triage today ->

Carlos Ruiz
July 31, 2020, 11:39 AM

Another finding in

Assignee

Heng Sin Low

Reporter

Heng Sin Low

Labels

None

Tested By

None

Components

Priority

Major
Configure