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.