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:00 +0000 (11:34 -0500)
commit5571be5f6edca81e4026b0403df40a2117b92a38
tree74c3d1a19e5894032dd7affc321e956883a8d24a
parent461d36ba0d9c72505493f20976150d95716ea0e7
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]