3606448 - Physical option OWNED BY is not reversed in existing sequences from PostgreSQL database - SAP PD

• 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.

• SAP PowerDesigner (PD) 16.7
• PostgreSQL 14.x

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