Changeset 9542 for trunk/Open-ILS/src/sql/Pg/011.schema.authority.sql

Timestamp:

05/09/08 12:31:09 (2 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/011.schema.authority.sql (modified) (1 diff)

trunk/Open-ILS/src/sql/Pg/011.schema.authority.sql

@@ -24 +24 @@
 CREATE TABLE authority.record_note (
         id              BIGSERIAL       PRIMARY KEY,
-        record          BIGINT          NOT NULL REFERENCES authority.record_entry (id),
+        record          BIGINT          NOT NULL REFERENCES authority.record_entry (id) DEFERRABLE INITIALLY DEFERRED,
         value           TEXT            NOT NULL,
         creator         INT             NOT NULL DEFAULT 1,