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:24:47 +0000 (11:24 -0500)
commit9f05aadd29c7f66344c146a91dfffabca381d131
tree667568f6d40f844dc91353b15946e53e9a096078
parent22cf746ef809470e630e98b75ac1021c3925e52f
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
Open-ILS/src/sql/Pg/t/lp1513554_do_not_delete_reserved_cancel_reasons.pg
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_protect_reserved_rows_from_delete.sql [new file with mode: 0644]