From 2ee54e937ef54575ee9b74709ba609f4bde5f702 Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Tue, 16 Aug 2011 17:16:35 -0400 Subject: [PATCH] Whitespace Only Changes Files uses primarily tabs, function used both spaces and tabs. It now uses all tabs. Signed-off-by: Dan Wells Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 48 +++++++++++------------ 1 file changed, 24 insertions(+), 24 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 75b379ed04..759d59a7bd 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -289,31 +289,31 @@ CREATE INDEX actor_org_unit_mailing_address_idx ON actor.org_unit (mailing_addre CREATE INDEX actor_org_unit_holds_address_idx ON actor.org_unit (holds_address); CREATE OR REPLACE FUNCTION actor.org_unit_parent_protect () RETURNS TRIGGER AS $$ - DECLARE - current_aou actor.org_unit%ROWTYPE; - seen_ous INT[]; - depth_count INT; + DECLARE + current_aou actor.org_unit%ROWTYPE; + seen_ous INT[]; + depth_count INT; BEGIN - current_aou := NEW; - depth_count := 0; - seen_ous := ARRAY[NEW.id]; - IF TG_OP = 'INSERT' OR NEW.parent_ou IS DISTINCT FROM OLD.parent_ou THEN - LOOP - IF current_aou.parent_ou IS NULL THEN -- Top of the org tree? - RETURN NEW; -- No loop. Carry on. - END IF; - IF current_aou.parent_ou = ANY(seen_ous) THEN -- Parent is one we have seen? - RAISE 'OU LOOP: Saw % twice', current_aou.parent_ou; -- LOOP! ABORT! - END IF; - -- Get the next one! - SELECT INTO current_aou * FROM actor.org_unit WHERE id = current_aou.parent_ou; - seen_ous := seen_ous || current_aou.id; - depth_count := depth_count + 1; - IF depth_count = 100 THEN - RAISE 'OU CHECK TOO DEEP'; - END IF; - END LOOP; - END IF; + current_aou := NEW; + depth_count := 0; + seen_ous := ARRAY[NEW.id]; + IF TG_OP = 'INSERT' OR NEW.parent_ou IS DISTINCT FROM OLD.parent_ou THEN + LOOP + IF current_aou.parent_ou IS NULL THEN -- Top of the org tree? + RETURN NEW; -- No loop. Carry on. + END IF; + IF current_aou.parent_ou = ANY(seen_ous) THEN -- Parent is one we have seen? + RAISE 'OU LOOP: Saw % twice', current_aou.parent_ou; -- LOOP! ABORT! + END IF; + -- Get the next one! + SELECT INTO current_aou * FROM actor.org_unit WHERE id = current_aou.parent_ou; + seen_ous := seen_ous || current_aou.id; + depth_count := depth_count + 1; + IF depth_count = 100 THEN + RAISE 'OU CHECK TOO DEEP'; + END IF; + END LOOP; + END IF; RETURN NEW; END; $$ LANGUAGE PLPGSQL; -- 2.43.2