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

Jason Etheridge jason at esilibrary.com
Fri Dec 18 13:23:57 EST 2009


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

-- 
Jason Etheridge
 | VP, Tactical Development
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  jason at esilibrary.com
 | web:  http://www.esilibrary.com

Please come by and visit the Equinox team
and learn more about Evergreen
ALA MidWinter
January 15-18, 2010
booth # 2064


More information about the Open-ils-dev mailing list