search

dalibo / sqlserver2pgsql

Migration tool to convert a Microsoft SQL Server Database into a PostgreSQL database, as automatically as possible
http://dalibo.github.io/sqlserver2pgsql
GNU General Public License v3.0
515 stars 117 forks source link

Add support for 'ON UPDATE SET NULL' clause in FK #156

Closed aminosbh closed 3 years ago

aminosbh commented 3 years ago

Add support for "ON UPDATE SET NULL" clause in Foreign Key Constraints.

PostgreSQL (v7.3 -> v13) supports the following clause: ON UPDATE <OPTION> where <OPTION> could be one of the following: RESTRICT, NO ACTION, SET NULL and SET DEFAULT

Reference: https://www.postgresql.org/docs/13/ddl-constraints.html https://www.postgresql.org/docs/7.3/ddl-constraints.html

madtibo commented 3 years ago

Thanks @aminosbh for this PR!