Symptom
- A sequence object is updated in a PostgreSQL model from a PostgreSQL database using a script file.
- The OWNED BY option is specified to associate the sequence with a specific table column.
- The OWNED BY value is not reversed in the model when OWNED BY is specified in an ALTER SEQUENCE statement.
As an example,
create table TABLE_1 (COLUMN_1 char(10) not null);
create sequence SEQUENCE_1;
alter sequence SEQUENCE_1 owned by TABLE_1.COLUMN_1; - It works fine when OWNED BY is specified in a CREATE SEQUENCE statement.
Read more...
Environment
- SAP PowerDesigner (PD) 16.7
- PostgreSQL 14.x
Product
SAP PowerDesigner 16.7
Keywords
PowerDesigner, PostgreSQL, sequence, OWNED BY, missing, reverse, re, alter, modify, add, definition, physical option, CR830737, CR#830737, 830737 , 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.