From 38a967b159327612ddfaaf4d210d7122e2a3e692 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 | 4 ++-- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 3dac060e47..33e9617b5c 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -236,7 +236,7 @@ $$; CREATE TABLE config.metabib_field_ts_map ( id SERIAL PRIMARY KEY, - metabib_field INT NOT NULL REFERENCES config.metabib_field (id), + metabib_field INT NOT NULL REFERENCES config.metabib_field (id) ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, ts_config TEXT NOT NULL REFERENCES config.ts_config_list (id), active BOOL NOT NULL DEFAULT TRUE, index_weight CHAR(1) NOT NULL DEFAULT 'C' CHECK (index_weight IN ('A','B','C','D')), @@ -253,7 +253,7 @@ $$; 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 fc6e09d0ed..66daf06a9e 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -197,7 +197,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