[OPEN-ILS-DEV] Removing records - Training Opportunity...

[James Fournie]

Hi Grant,

Looks like you want to use IN instead of =

# DELETE from metabib.metarecord_source_map where source IN (SELECT id
FROM biblio.record_entry where tcn_value like 'cis%');

~James Fournie
BC SITKA Team

On Wed, Oct 22, 2008 at 1:54 PM, Grant Johnson <FGJohnson at upei.ca> 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.
>
> 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
>
>