On Thu, Oct 16, 2008 at 2:27 PM, Grant Johnson <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] | 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 <[EMAIL PROTECTED]>, > "Grant Johnson" <[EMAIL PROTECTED]> 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? > >
