SAP Knowledge Base Article - Preview

3234168 - PostgreSQL identity columns are still generated as SERIAL columns - SAP PD

Symptom

  • Creating an identity column in a PostgreSQL PDM, PD uses SERIAL to create a sequential integer.
  • PostgreSQL 10 introduced the GENERATED AS IDENTITY syntax.
    For example,
       create table TABLE_1 (
          COLUMN_1   int8   NOT NULL GENERATED ALWAYS AS IDENTITY
       ); 


Read more...

Environment

  • SAP PowerDesigner 16.7
  • PostgreSQL 9.x (expected behavior) and 14.x (reproduced)

Product

SAP PowerDesigner 16.7

Keywords

"by default", CR#826997, CR826997, 826997 , KBA , BC-SYB-PD , PowerDesigner , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.