[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