Symptom
- Foreign key constraint is defined without the ON UPDATE and/or ON DELETE clause.
- When reversing a SQL script, these clauses are created with the RESTRICT action, even though the default value is NO ACTION in PostgreSQL.
Read more...
Environment
- SAP PowerDesigner (PD) 16.7
- PostgreSQL 14.x
Product
SAP PowerDesigner 16.7
Keywords
PowerDesigner, PostgreSQL, PSQL, NO ACTION, RESTRICT, Reverse Engineering, RE, Foreign Key, FK, reference, constraint, action, operation, CR830739, CR#830739, 830739 , 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.
SAP Knowledge Base Article - Preview