No Audit Table for acq.lineitem_detail
Bug #1965797 reported by
Jennifer Pringle
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Wishlist
|
Unassigned |
Bug Description
Evergreen 3.8
There are currently no audit tables for acq.lineitem_detail so if a copy on a line item is changed or deleted there is no way to track the changes or confirm the existence of the deleted copy.
This has caused issues for us a few times as we're unable to track back what actually happened when troubleshooting.
tags: | added: acq database |
Changed in evergreen: | |
status: | New → Confirmed |
Changed in evergreen: | |
assignee: | nobody → Josh Stompro (u-launchpad-stompro-org) |
Changed in evergreen: | |
importance: | Undecided → Wishlist |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
You can add the auditor yourself using the acq.create_ acq_auditor database function. The following would create an audit table on acq.lineitem_ detail:
select acq.create_ acq_auditor( 'acq', 'lineitem_detail');
If you think it should be created by default in new schemas, that's a valid bug request. I'm not sure that we should add it via an upgrade script.