SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP PowerDesigner 16.7

Keywords

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

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.