Missed a deferrable constraint
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 13 May 2008 14:52:21 +0000 (14:52 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 13 May 2008 14:52:21 +0000 (14:52 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@9577 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/040.schema.asset.sql

index dcf57a0..1a17d9e 100644 (file)
@@ -7,7 +7,7 @@ CREATE SCHEMA asset;
 CREATE TABLE asset.copy_location (
        id              SERIAL  PRIMARY KEY,
        name            TEXT    NOT NULL,
-       owning_lib      INT     NOT NULL REFERENCES actor.org_unit (id),
+       owning_lib      INT     NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED,
        holdable        BOOL    NOT NULL DEFAULT TRUE,
        opac_visible    BOOL    NOT NULL DEFAULT TRUE,
        circulate       BOOL    NOT NULL DEFAULT TRUE