From e4bc9e8972ecfb9d7040e894a2deb3410ffdf70c Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 6 Jul 2017 17:09:02 -0400 Subject: [PATCH] serials: Allow cascading delete of issuances from scap Signed-off-by: Mike Rylander --- .../sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql new file mode 100644 index 0000000000..d27f8bc974 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql @@ -0,0 +1,18 @@ +BEGIN; + +ALTER TABLE serial.issuance DROP CONSTRAINT IF EXISTS issuance_caption_and_pattern_fkey; + +-- Using NOT VALID and VALIDATE CONSTRAINT limits the impact to concurrent work. +-- For details, see: https://www.postgresql.org/docs/current/static/sql-altertable.html + +ALTER TABLE serial.issuance ADD CONSTRAINT issuance_caption_and_pattern_fkey + FOREIGN KEY (caption_and_pattern) + REFERENCES serial.caption_and_pattern (id) + ON DELETE CASCADE + DEFERRABLE INITIALLY DEFERRED + NOT VALID; + +ALTER TABLE serial.issuance VALIDATE CONSTRAINT issuance_caption_and_pattern_fkey; + +COMMIT; + -- 2.11.0