https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271 --- Comment #201 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (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.