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.