Changeset 9543 for branches/rel_1_2/Open-ILS/src/sql/Pg/011.schema.authority.sql

Timestamp:

05/09/08 12:34:30 (5 months ago)

Author:

dbs

Message:

Merge rev. 9542 from trunk: add deferrable to all FKs

Files:

• branches/rel_1_2/Open-ILS/src/sql/Pg/011.schema.authority.sql (modified) (1 diff)

branches/rel_1_2/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,