I don't want to change the table constraints in Evergreen. But have a training opportunity for someone. :-)
We need to delete some electronic records without items from the catalog.(for now). These records have a biblio.record_entry.tcn_source of LIKE 'cis'. I can't delete from biblio.record_entry as it's referenced as a foreign_key in .metarecord. I can't delete from .metarecord as it's referenced as a foreign key in .metarecord_source_map. I CAN remove the rows one at a time from the msm -> m -> re and the record is gone. Can someone help with the syntax on how to batch delete the following..... and let me know if this is all wrong! I know what this means - and am looking up how to build the syntax tonight: - ERROR: more than one row returned by a subquery used as an expression... :-) # DELETE from metabib.metarecord_source_map where source = (SELECT id FROM biblio.record_entry where tcn_value like 'cis%'); # DELETE from metabib.metarecord where master_record = ((SELECT id FROM biblio.record_entry where tcn_value like 'cis%'); # DELETE from biblio.record_entry where tcn_value like 'cis%'); Table References: biblio.record_entry id = 14497 metabib.metarecord id=17448 master_record=14497 metaib.metarecord_source_map id=14710 metarecord=17448 source=14497 -- F. Grant Johnson Systems Coordinator Robertson Library University of Prince Edward Island
