SAP Knowledge Base Article - Preview

3606641 - Foreign key constraint with no clause is reversed with ON UPDATE/ON DELETE RESTRICT in a PostgreSQL model - SAP PD

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.