PRTEAM table needs a unique not null key on PG

book

Article ID: 225757

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

PRTEAM table needs a unique not null key on PostgreSQL in order to reclaim space online

STEPS TO REPRODUCE:

  1. Check table PRTEAM describe DDL definition
  2. Note there is no Primary Key or UNIQUE NOT NULL KEY. PRID is nullable

Expected Results: PRTEAM to have primary key or not-null unique key

Actual Results: No primary key/not-null unique key on this table, which requires Full Vacuum to be run on the table to reclaim space (requiring downtime)

Environment

Release : 15.9.3

Resolution

  • This is DE62846, in review by Engineering
  • Request downtime for full vacuum on this table to remove bloat