SAP Knowledge Base Article - Preview

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

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.