Obj Methods return properties in lower case - PostgreSQL
When PEGA is used with Oracle-RDS, all Obj methods return UPPERCASE properties, but when used with PostgreSQL it returns lowercase properties. This is causing an issue when migrating applications across Databases. Is there a DSS or configuration to ensure SQL generated by PEGA when interacting with DB can be defaulted to UPPER / lower case?
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of our Pega Support Community homepage. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.
Could you please elaborate where should we define this. From Pega we have external mapping of properties which is already there.No issue with Obj-Browse but at the time of obj-open/Obj-Open_by Handle we are facing this upper case columns issue.