3604382 - Reverse of Foreign Key Constraint replaces NO ACTION by RESTRICT actions in PostgreSQL - SAP PD

• NO ACTION is specified in a SQL script using the ON DELETE and ON UPDATE clauses of a foreign key constraint.
  
  
• Value NO ACTION is replaced by RESTRICT when reversing the SQL script in a PostgreSQL model.
  As an example,
     create table TABLE_1 (
        COLUMN_1   char(10)   not null,
        constraint PK_TABLE_1 primary key (COLUMN_1)
     );
     create table TABLE_2 (
        COLUMN_2   char(10)   not null,
        COLUMN_1   char(10),
        constraint PK_TABLE_2 primary key (COLUMN_2)
     );
     alter table TABLE_2
        add constraint FK_REFERENCE_1 foreign key (COLUMN_1)
           references TABLE_1 (COLUMN_1)
           on delete no action on update no action;

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

PowerDesigner, PostgreSQL, PSQL, NO ACTION, RESTRICT, CASCADE, NONE, SET NULL, SET DEFAULT, Reverse Engineering, RE, Foreign Key, FK, reference, constraint, action, operation, CR830738, CR#830738, 830738 , KBA , BC-SYB-PD , PowerDesigner , Known Error