From: Rogan Hamby Date: Tue, 21 Jul 2020 13:28:53 +0000 (-0400) Subject: fixing thinko X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=d1ba7e34fbccf0ce88658767460ed9914b3994b8 fixing thinko --- diff --git a/remove_ou_data/00_check_admin_user.sql b/remove_ou_data/00_check_admin_user.sql index 6d6eb9d..3702ba7 100644 --- a/remove_ou_data/00_check_admin_user.sql +++ b/remove_ou_data/00_check_admin_user.sql @@ -20,11 +20,12 @@ \timing -- these scripts assume that the admin user's home_ou is 1, if not there can be problems +-- replace 'equinox' with the appropriate admin name DO $$ DECLARE x INTEGER; BEGIN - SELECT home_ou FROM actor.usr INTO x; + SELECT home_ou FROM actor.usr WHERE usrname = 'equinox' INTO x; IF x != 1 THEN RAISE EXCEPTION 'Admin user is not home org of 1'; END IF; END $$;