hmmmm.. But I'm thinking that if I didn't remove them from the other tables there would be too much db clutter for my wee brain! Perhaps in 6 months I might have different synaptic connections.
-- F. Grant Johnson Systems Coordinator Robertson Library University of Prince Edward Island >>> On 2008/10/22 at 8:28 PM, in message <[EMAIL PROTECTED]>, "Mike Rylander" <[EMAIL PROTECTED]> wrote: > On Wed, Oct 22, 2008 at 4:54 PM, Grant Johnson <[EMAIL PROTECTED]> wrote: >> 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. > > > If /all/ you want to do is make sure that these can never show up in > search results (opac or staff client) and you're on 1.2.2.0 or higher > (you are, of course, but for list memory...) then deleting from msm is > enough, actually. IFF that's the case, then your first DELETE > statement below, adjusted as mentioned by James, is all you'll need. > > --miker > >> >> 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 >> >> > >