Script to delete records containing error record data

The following script deletes records that are contained in error_records_lb table:

SET SEARCH_PATH = '{tenantId}_mod_source_record_storage';
BEGIN;

DELETE FROM records_lb
WHERE id IN (SELECT id FROM error_records_lb);

DELETE FROM marc_indexers
WHERE marc_id IN (SELECT id FROM error_records_lb);

DELETE FROM marc_records_tracking
WHERE marc_id IN (SELECT id FROM error_records_lb);

DELETE FROM error_records_lb;

COMMIT;