From d1ba7e34fbccf0ce88658767460ed9914b3994b8 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 21 Jul 2020 09:28:53 -0400 Subject: [PATCH] fixing thinko --- remove_ou_data/00_check_admin_user.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) 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 $$; -- 1.7.2.5