Change #3751
| Category | None |
| Changed by | Mike Rylander <mrylander@gmail.com> |
| Changed at | Tue 17 Jan 2017 15:12:18 |
| Repository | git://git.evergreen-ils.org/Evergreen.git |
| Project | Evergreen |
| Branch | master |
| Revision | bdae9864b7992597a469fbbc8ef91fe7bf87b50b |
Comments
LP#1657237: Properly constrain matview trigger function
The function maintaining the reporter.hold_request_record table
was performing an unconstrained update when a hold was moved. This
fixes that.
To test:
[1] Apply the patch, the perform an asset merge that would
change the target of a hold request. Verify that
reporter.hold_request_record is properly update.
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Bill Erickson <berickxx@gmail.com>
Changed files
- Open-ILS/src/sql/Pg/reporter-schema.sql
- Open-ILS/src/sql/Pg/upgrade/XXXX.function.hold-move-trigger-bug.sql