[OPEN-ILS-DEV] Removing records

[Mike Rylander]

On Thu, Oct 16, 2008 at 2:27 PM, Grant Johnson <fgjohnson at upei.ca> wrote:
> I take it that it is not as easy as deleting rows from the biblio.record_entry table!?!

It is that easy.  However, to /really/ delete them you'll need to drop
(and later reapply) the rule protecting against true deletes on that
table:

BEGIN;
DROP RULE protect_bib_rec_delete ON biblio.record_entry;
--
-- ... delete some records ...
--
CREATE RULE protect_bib_rec_delete AS ON DELETE TO biblio.record_entry
DO INSTEAD UPDATE biblio.record_entry SET deleted = TRUE WHERE OLD.id
= biblio.
record_entry.id;
COMMIT;

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com


>
> --
>
> F. Grant Johnson
>  Systems Coordinator
>  Robertson Library
>  University of Prince Edward Island
>
>>>> On 2008/10/16 at 2:10 PM, in message <48F74B59.5AB7.007F.0 at groupwise.upei.ca>,
> "Grant Johnson" <fgjohnson at upei.ca> wrote:
>> Hey,
>> I have the import down but I need to "remove" some records that have dummy
>> item records. (Starting with XX)
>> Specifically ebrary and Springer I think- to avoid duplication.
>>
>> New imports will be transcendent without an item record.
>>
>> What is the process for deleting records in batch?
>
>