LP#1657237: Properly constrain matview trigger function
authorMike Rylander <mrylander@gmail.com>
Tue, 17 Jan 2017 19:46:36 +0000 (14:46 -0500)
committerBill Erickson <berickxx@gmail.com>
Tue, 17 Jan 2017 20:14:13 +0000 (15:14 -0500)
commit49b5ae1bc4eaedbf7b42d6f5b38fbe9be2d22700
treefba94a2de48ec9c976b89d45f058d288d680ec33
parentc957bbf9a32bbacf37a5f20832cab3ec4885e326
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>
Open-ILS/src/sql/Pg/reporter-schema.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.hold-move-trigger-bug.sql [new file with mode: 0644]