Until the API gets fixed to clean things up correctly, here's a PostgreSQL anonymous code block which cleans up the stuff it leaves behind which we used: DO $
DECLARE
u record;
r record;
p record;
BEGIN
FOR u IN select id, login_id from x_portal_user where login_id not in (select user_name from x_user)
LOOP
RAISE NOTICE 'User roles in x_portal_user_role:';
FOR r IN select id, user_id, user_role from x_portal_user_role where user_id = u.id
LOOP
RAISE NOTICE USING MESSAGE = ' ' || r.user_role;
RAISE NOTICE USING MESSAGE = 'DELETE from x_portal_user_role WHERE id = ' || r.id;
-- Uncomment next line to perform action
--EXECUTE 'DELETE from x_portal_user_role WHERE id = ' || r.id;
END LOOP;
RAISE NOTICE 'User permissions in x_user_module_perm:';
FOR p IN select id, user_id, module_id from x_user_module_perm where user_id = u.id
LOOP
RAISE NOTICE USING MESSAGE = ' ' || (select module from x_modules_master where id = p.module_id);
RAISE NOTICE USING MESSAGE = 'DELETE from x_user_module_perm where id = ' || p.id;
-- Uncomment next line to perform action
--EXECUTE 'DELETE from x_user_module_perm where id = ' || p.id;
END LOOP;
RAISE NOTICE USING MESSAGE = 'DELETE FROM x_portal_user WHERE id = ' || u.id;
-- Uncomment next line to perform action
--EXECUTE 'DELETE FROM x_portal_user WHERE id = ' || u.id;
RAISE NOTICE ' ';
END LOOP;
END$;
... View more
