dbdiff icon indicating copy to clipboard operation
dbdiff copied to clipboard

Does not seem to handle FK ON DELETE CASCADE change

Open siyb opened this issue 8 years ago • 0 comments

Source: TABLE "systemrole" CONSTRAINT "fk474jpkeb2oe23px6stixe16wh" FOREIGN KEY (id) REFERENCES role(id) ON DELETE CASCADE

Target: TABLE "systemrole" CONSTRAINT "fk474jpkeb2oe23px6stixe16wh" FOREIGN KEY (id) REFERENCES role(id)

Command:

dbdiff -l drop $TARGET $SOURCE

Result:

Alter table statements containing not mention of ON DELETE CASCADE

Expected Result:

Alter table statements containing ON DELETE CASCADE changes (drop / recreate for instance)

siyb avatar Apr 03 '17 14:04 siyb