[OPEN-ILS-DEV] Preventing duplicate entries in bookbags / record buckets
Dan Scott
dan at coffeecode.net
Tue Dec 22 09:59:35 EST 2009
On Tue, 2009-12-22 at 09:38 -0500, Mike Rylander wrote:
> 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.
>
I meant to say, I like the sounds of it. Thanks for injecting some
sanity back into my world, Mike :)
More information about the Open-ils-dev
mailing list