[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