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)
10 FROM (SELECT DISTINCT ON (fingerprint)
11 fingerprint, id, quality
12 FROM biblio.record_entry
13 ORDER BY fingerprint, quality desc) AS x
14 WHERE fingerprint IS NOT NULL;
16 INSERT INTO metabib.metarecord_source_map (metarecord,source)
18 FROM biblio.record_entry b
19 JOIN metabib.metarecord m ON (m.fingerprint = b.fingerprint);
21 ALTER TABLE metabib.metarecord_source_map ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id);
25 VACUUM FULL ANALYZE VERBOSE metabib.metarecord;
26 VACUUM FULL ANALYZE VERBOSE metabib.metarecord_source_map;