3 ALTER TABLE metabib.metarecord_source_map DROP CONSTRAINT metabib_metarecord_source_map_metarecord_fkey;
5 TRUNCATE metabib.metarecord;
6 TRUNCATE metabib.metarecord_source_map;
8 INSERT INTO metabib.metarecord (fingerprint,master_record)
9 SELECT fingerprint,min(id)
10 FROM biblio.record_entry
11 WHERE fingerprint IS NOT NULL
14 INSERT INTO metabib.metarecord_source_map (metarecord,source)
16 FROM biblio.record_entry b
17 JOIN metabib.metarecord m ON (m.fingerprint = b.fingerprint);
19 ALTER TABLE metabib.metarecord_source_map ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id);
23 VACUUM FULL ANALYZE VERBOSE metabib.metarecord;
24 VACUUM FULL ANALYZE VERBOSE metabib.metarecord_source_map;