[OPEN-ILS-DEV] Authority Record Linking script

[Duimovich, George]

Hello,

The authority_control_fields.pl script provides handy tool to create authority record / bib record linkages.  

In earlier upgrade testing I removed duplicates from our production "authority.record_entry" table  using a delete by id statement.  Duplicates were identified and then rows were deleted from entries that had known lower quality sources, etc.

Problem: my delete query against "authority.record_entry" didn't seem to auto-update the related index entries in "authority.full_rec"   -- we can still find rows in "authority.full_rec" that point to authority records that had been deleted.  And since the "authority_control_fields.pl" script uses those values from "authority.full_rec" it runs into trouble when it finds a reference to a value's id that is no longer in "authority.record_entry". So I've removed duplicates from record_entry, but full_rec still has references to duplicate index values.

Question: How can I completely refresh / rebuild the "authority.full_rec" table so that we have a clean table for "authority_control_fields.pl" to use?

George

George Duimovich
NRCan Library / Bibliothèque de RNCan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110516/444c0ac7/attachment.htm