From 00afeca6dbcb4b07ea2754d781572395e76abb07 Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Wed, 9 Oct 2013 09:29:01 -0400 Subject: [PATCH] Make some FK constraints on config.metabib_field.id deferrable Signed-off-by: Dan Wells Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 495b55e91c..d9a4697c0e 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -201,7 +201,7 @@ CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field CREATE TABLE config.metabib_search_alias ( alias TEXT PRIMARY KEY, field_class TEXT NOT NULL REFERENCES config.metabib_class (name), - field INT REFERENCES config.metabib_field (id) + field INT REFERENCES config.metabib_field (id) ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED ); CREATE TABLE config.non_cataloged_type ( diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 264e4e64e6..acaa671eb1 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -149,7 +149,7 @@ CREATE TRIGGER metabib_browse_entry_fti_trigger CREATE TABLE metabib.browse_entry_def_map ( id BIGSERIAL PRIMARY KEY, entry BIGINT REFERENCES metabib.browse_entry (id), - def INT REFERENCES config.metabib_field (id), + def INT REFERENCES config.metabib_field (id) ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, source BIGINT REFERENCES biblio.record_entry (id) ); CREATE INDEX browse_entry_def_map_def_idx ON metabib.browse_entry_def_map (def); -- 2.11.0