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:14:12 +0000 (10:14 -0400)
commit4cb016adb610dc22e0671c20345abca7744ecfe5
treec1a2305764635be54a852b69e8e5c9e0372c4797
parent8589cf090b400c2e4e35233825e45027a4fde15d
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