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;
15 INSERT INTO metabib.metarecord_source_map (metarecord,source)
17 FROM biblio.record_entry b
18 JOIN metabib.metarecord m ON (m.fingerprint = b.fingerprint);
20 ALTER TABLE metabib.metarecord_source_map ADD CONSTRAINT metabib_metarecord_source_map_metarecord_fkey FOREIGN KEY (metarecord) REFERENCES metabib.metarecord (id);
24 VACUUM FULL ANALYZE VERBOSE metabib.metarecord;
25 VACUUM FULL ANALYZE VERBOSE metabib.metarecord_source_map;