[OPEN-ILS-DEV] Preventing duplicate entries in bookbags / record buckets

Mike Rylander mrylander at gmail.com
Tue Dec 22 09:38:38 EST 2009


On Fri, Dec 18, 2009 at 1:23 PM, Jason Etheridge <jason at esilibrary.com> wrote:
>> I'd say, add a "unique_items" bool to the container table, and have a
>> trigger on the item table check that in a BEFORE UPDATE OR INSERT
>> trigger.  Eh?
>
> I like this.  Do we want to silently turn an INSERT into an UPDATE on
> collision or provide an error?
>

Anyone else want to weigh in?  This should be fairly simple to
backport to 1.6 for 1.6.1.

-- 
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


More information about the Open-ils-dev mailing list