https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271
--- Comment #201 from Jonathan Druart <[email protected]> --- (In reply to Kyle M Hall from comment #200) > > We could have a boolean flag is_deleted, in addition of deleted_on that > > contains an important info. The problem is that it will not work either, as: > > The following situation should be valid but will fail the unique constraint: > > (id, is_deleted) > > (42, 1) > > (42, 0) > > (42, 0) > > I don't think I understand what scenario would create a situation such as > this, could you elaborate? Sorry, wrong copy/paste, it was the reverse: (id, is_deleted) (42, 0) (42, 1) (42, 1) So barcode=42 can appear several times, but only once with is_deleted=0. Result is the same, the constraint will fail. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
