From: Mike Rylander <miker@esilibrary.com>
Date: Fri, 22 Aug 2008 01:18:07 +0000 (+0000)
Subject: commenting out parts that should not be run in 8.2.9 inside the initial import transa... 
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=6a5938658049d40e8bb94d9a9e6689503a54a508

commenting out parts that should not be run in 8.2.9 inside the initial import transaction
---

diff --git a/clear-db.sql b/clear-db.sql
index 885ef0c..7e31652 100644
--- a/clear-db.sql
+++ b/clear-db.sql
@@ -100,6 +100,8 @@ CREATE INDEX metabib_full_rec_index_vector_idx ON metabib.full_rec USING GIST (i
 CREATE INDEX metabib_full_rec_tag_subfield_idx ON metabib.full_rec (tag,subfield);
 CREATE INDEX metabib_full_value_idx ON metabib.full_rec (value);
 
+/*  Run the AFTER committing ...
+
 ALTER TABLE metabib.metarecord_source_map DROP CONSTRAINT metabib_metarecord_source_map_metarecord_fkey;
 
 TRUNCATE metabib.metarecord;
@@ -122,8 +124,14 @@ ALTER TABLE metabib.metarecord_source_map
 	ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey
 		FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id) DEFERRABLE INITIALLY DEFERRED;
 
+*/
+
+
+/* And this too, if it's production
+
 SELECT reporter.enable_materialized_simple_record_trigger();
 
+*/
 
 -- COMMIT;
 -- VACUUM FULL;