From 2e239c3bf8dad03871cfe7fdfe598bb0caf59504 Mon Sep 17 00:00:00 2001 From: dbs Date: Tue, 8 Jul 2008 16:32:21 +0000 Subject: [PATCH] Backport r9912: * Another constraint that needs to be DEFERRED INITIALLY DEFERRED git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@9987 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/quick_metarecord_map.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Evergreen/src/extras/import/quick_metarecord_map.sql b/Evergreen/src/extras/import/quick_metarecord_map.sql index 89a8364d8a..01075b5199 100644 --- a/Evergreen/src/extras/import/quick_metarecord_map.sql +++ b/Evergreen/src/extras/import/quick_metarecord_map.sql @@ -18,7 +18,7 @@ INSERT INTO metabib.metarecord_source_map (metarecord,source) FROM biblio.record_entry b JOIN metabib.metarecord m ON (m.fingerprint = b.fingerprint); -ALTER TABLE metabib.metarecord_source_map ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id); +ALTER TABLE metabib.metarecord_source_map ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id) DEFERRABLE INITIALLY DEFERRED; COMMIT; -- 2.11.0