Posted: 30 Apr 2020 1:35 EDT Last activity: 15 Jun 2020 10:24 EDT
Upper case and Lower case issue with PostgreSQL database
In PostgreSQL, database objects name (column name, table name, etc) are handled in lower case. This is by their design, and it's not up to us. Let's say, we create a class and properties with letters that starts with upper case (This is a Java/Pega standard practice) as below.
Pega Platform automatically creates a table and columns as below - all with lower case letters.
This causes an issue. For example, if I use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence I can't reference to the data by Property name.
In order to avoid this issue, I have to map them in the class form as below.
This issue has been a while but is there any enhancement yet? This bug doesn't happen in Oracle.
FYI, below link talks about the same issue but there is not applicable solution provided.