]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3e2179e) | patch
LP#1533331 - Fix evergreen.protect_reserved_rows_from_delete() trigger function
authorChris Sharp <csharp@georgialibraries.org>
Mon, 8 Feb 2016 18:00:06 +0000 (13:00 -0500)
committerJason Stephenson <jstephenson@mvlc.org>
Fri, 4 Mar 2016 16:34:21 +0000 (11:34 -0500)
commitc3b95afaad2d3ceb5a8e31607be6e5c4bea0d499
tree0e2734973ae97e8e17edef629ca12e5c1ffdb999tree
parent3e2179e781d1c2440524439f4287b4c31b9a8825commit | 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>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.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