diff options
author | Christopher Baines <mail@cbaines.net> | 2020-10-02 18:14:40 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-10-02 20:15:10 +0100 |
commit | 841f5fb18697a545f083e48e2b1e3ab47e4312e4 (patch) | |
tree | 2cbf1d634873b77bbf3f01bcffb01ae9a034ae29 /sqitch/verify/change_derivation_source_file_nars_constraint.sql | |
parent | 125a35fce557ed0c73872944c04ec39d10b4ca1c (diff) | |
download | data-service-841f5fb18697a545f083e48e2b1e3ab47e4312e4.tar data-service-841f5fb18697a545f083e48e2b1e3ab47e4312e4.tar.gz |
Change a constraint to add ON DELETE CASCADE
I've not used these in many places, to try and avoid hiding deleting data, but
in this case, this will allow more easily deleting the derivation source file
nars, by just deleting the derivation_source_files table entry.
Diffstat (limited to 'sqitch/verify/change_derivation_source_file_nars_constraint.sql')
-rw-r--r-- | sqitch/verify/change_derivation_source_file_nars_constraint.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/verify/change_derivation_source_file_nars_constraint.sql b/sqitch/verify/change_derivation_source_file_nars_constraint.sql new file mode 100644 index 0000000..7c00429 --- /dev/null +++ b/sqitch/verify/change_derivation_source_file_nars_constraint.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:change_derivation_source_file_nars_constraint on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |