Whitespace Only Changes
authorDan Wells <dbw2@calvin.edu>
Tue, 16 Aug 2011 21:16:35 +0000 (17:16 -0400)
committerDan Scott <dan@coffeecode.net>
Thu, 18 Aug 2011 23:24:24 +0000 (19:24 -0400)
Files uses primarily tabs, function used both spaces and tabs.
It now uses all tabs.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Dan Scott <dscott@laurentian.ca>

Open-ILS/src/sql/Pg/005.schema.actors.sql

index 75b379e..759d59a 100644 (file)
@@ -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;