Question

5
Replies
229
Views
Kensho Tsuchihashi (KenshoTsuchihashi)
PEGA
Project Delivery Leader
Pegasystems Inc.
JP
KenshoTsuchihashi Member since 2010 139 posts
PEGA
Posted: April 30, 2020
Last activity: March 1, 2021
Posted: 30 Apr 2020 1:35 EDT
Last activity: 1 Mar 2021 21:37 EST

Upper case and Lower case issue with PostgreSQL database

Hi,

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 Pega. 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.

Class & Properties with Upper Case and Lower Case

Pega Platform automatically creates a table and columns as below - all with lower case letters.

PostgreSQL Table and Column with all lower case

This may sometimes cause an issue. For example, if you use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence you won't be able to reference the data by Property name.

data loaded with lower cases

In order to avoid this issue, you'll need to map them in the class form as below.

External Mapping

This issue has been a while but is there any enhancement yet? It doesn't happen in Oracle.

 

FYI, below link talks about the same issue but there is not applicable solution provided.

https://collaborate.pega.com/question/obj-methods-return-properties-lower-case-postgresql

 

Thanks,

 

 

***Edited by Moderator Marissa to update Platform Capability tags****

Pega Platform 8.4 Data Integration