]> git.evergreen-ils.org Git - Evergreen.git/commit
Prevent OU loops at DB level
authorThomas Berezansky <tsbere@mvlc.org>
Thu, 16 Jun 2011 02:03:38 +0000 (22:03 -0400)
committerMike Rylander <mrylander@gmail.com>
Sat, 16 Jul 2011 14:05:50 +0000 (10:05 -0400)
commite5d63d761e2156c78004f48e2620e5d1a63084ae
tree4a921d390b193eca87c2ccc5c7793aa17bb19d80
parent79d40f168307d73497ef7d54a382c2cdd9816643
Prevent OU loops at DB level

Database trigger to prevent actor.org_unit from being parent of self

Actually detects any loops, even those above the current point

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/005.schema.actors.sql