Changeset 9542 for trunk/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql

Timestamp:

05/09/08 12:31:09 (5 months ago)

Author:

dbs

Message:

Make all foreign keys deferrable, so we can DELETE and INSERT inside a transaction without constraints hobbling us

Files:

• trunk/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql (modified) (1 diff)

trunk/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql

@@ -171 +171 @@
     id          SERIAL  PRIMARY KEY,
     active      BOOL    NOT NULL DEFAULT TRUE,
-    field       INT     NOT NULL REFERENCES config.metabib_field (id),
+    field       INT     NOT NULL REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED,
     bump_type   TEXT    NOT NULL CHECK (bump_type IN ('word_order','first_word','full_match')),
     multiplier  NUMERIC NOT NULL DEFAULT 1.0