Close popover
Manoj Sarvepalli (MANOJPDN)
Rulesware LLC
Principal Consultant
Rulesware LLC
MANOJPDN Member since 2009 22 posts
Rulesware LLC
Posted: January 12, 2016
Last activity: January 17, 2016

Some Tables from OOTB Pega 7 are missing primary keys on them

There are some tables in pega 7 ( we are using Pega717/718)  which do not have  Primary keys defined on them. For example pr_sys_updatescache and pr_index_Info.  In some of our client places when trying to upgrade to  Pega7 or  creating new Pega7 environment the Client Database teams are rejecting creation of such tables with out primary keys.  GCS recommended us to post this question here. I am looking for details/info around why these tables deliberately left without  a primary key by pega , and are there any plans for pega to add  keys to these tables in future. If client insists on standards can we go ahead an create a new column and make it primary key. What are Pega's thoughts around this.

System Administration
Moderation Team has archived post