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.