projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 79d40f1) | patch
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
tree4a921d390b193eca87c2ccc5c7793aa17bb19d80tree
parent79d40f168307d73497ef7d54a382c2cdd9816643commit | diff
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 diff | blob | history
Evergreen working repo (Equinox)