From 6a5938658049d40e8bb94d9a9e6689503a54a508 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 22 Aug 2008 01:18:07 +0000 Subject: [PATCH] commenting out parts that should not be run in 8.2.9 inside the initial import transaction --- clear-db.sql | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) 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; -- 1.7.2.5