projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: bfd440d) | 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:08:30 +0000 (10:08 -0400)
commitb210ac5d407148ee7b81fc00d26feffafebeffd0
tree5868f8b3ce9257cbbfca0e45fd9bc19f11e89bbftree
parentbfd440d9150ae2812ff50e2e27cfbd4bf0fc96d2commit | 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 ILS