Hi, On Fri, Apr 26, 2013 at 12:11 PM, Joshua D. Drake <[email protected]> wrote: > Dropping the partial index and only relying on asset.copy(barcode):
Dropping the partial index also means dropping the constraint enforcing the uniqueness of non-deleted item barcodes. That's a pretty important constraint as far as the business logic is concerned. Of course, there is nothing preventing an Evergreen user from *also* adding a full (non-unique) index on asset.copy (barcode); that could certainly be useful if they expect to be doing a lot of ad hoc queries on withdrawn items where the barcode is a relevant query filter. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: [email protected] direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
