xataio / pgroll

PostgreSQL zero-downtime migrations made easy
https://www.xata.io
Apache License 2.0
3.56k stars 67 forks source link

Respect foreign key `ON DELETE` in add column and create table operations #308

Closed andrew-farries closed 8 months ago

andrew-farries commented 8 months ago

297 added the ability to specify the ON DELETE behavior of a foreign key when altering an existing column.

Make it so that the ON DELETE property of the the FK is respected for FKs on new columns too (ie those created by add column and create table operations).

Fixes #306