Unable to delete copy notes / remove items from buckets, etc.
Bug #1724223 reported by
Jason Boyer
This bug affects 5 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Eg 3.0
One of the upgrade scripts in bug 1708291 changed the type of fkey constraints on asset.copy to be trigger based to allow serial.unit items to be used in many of the same places. But a combination of issues (calling the trigger on DELETE and using NEW when TG_OP='DELETE') it's not possible to remove anything that has an fkey relationship protected with these triggers. (So you can't delete a copy note or copy tag, remove a copy from a bucket, and so on.) Since most of the tables affected allow real deletes there's little point in worrying about whether they point to a real copy before deleting them. Small fix incoming.
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
milestone: | none → 3.0.2 |
assignee: | nobody → Galen Charlton (gmc) |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
And here it is: http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ jboyer/ lp1724223_ inh_fkey_ fix