]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1c96050) | patch
LP#1533331 - Fix evergreen.protect_reserved_rows_from_delete() trigger function user/csharp/lp1533331_fix_protect_reserved_rows_from_delete
authorChris Sharp <csharp@georgialibraries.org>
Mon, 8 Feb 2016 18:00:06 +0000 (13:00 -0500)
committerChris Sharp <csharp@georgialibraries.org>
Thu, 3 Mar 2016 15:54:23 +0000 (10:54 -0500)
commite8b63566c79a9519ac0dd4908f05293a9a02913d
tree9ada4f72eb1432f99ee99c50697b9bcb21d81267tree
parent1c9605039f08e016974046941ee192a0e7b767b6commit | diff
LP#1533331 - Fix evergreen.protect_reserved_rows_from_delete() trigger function

The fix for bug 1513554 included creating a general trigger function to prevent
the deletion of reserved table rows with an ID lower than a specified threshold.
Testing for that seemed to pass muster, but using the function in practice revealed
a failure to delete deletable rows either.

This adds an explicit RETURN to the function, which fixes the issue.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Open-ILS/src/sql/Pg/000.functions.general.sql diff | blob | history
Open-ILS/src/sql/Pg/t/lp1513554_do_not_delete_reserved_cancel_reasons.pg diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_protect_reserved_rows_from_delete.sql [new file with mode: 0644] blob
Evergreen ILS