X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/e984ef977fd3def1ee1baa2352f2cc357e07bbe1..4da47473feda7571d88722b17a98cd5e01ffa43f:/reg_svr/reg_svr.pc

diff --git a/reg_svr/reg_svr.pc b/reg_svr/reg_svr.pc
index 79d209ca..a8616151 100644
--- a/reg_svr/reg_svr.pc
+++ b/reg_svr/reg_svr.pc
@@ -1006,6 +1006,13 @@ int check_username_available(char *username)
   if (count != 0)
     return MR_IN_USE;
 
+  EXEC SQL SELECT COUNT(login) INTO :count FROM userhistory
+    WHERE login = :username;
+  if (sqlca.sqlcode)
+    return MR_DBMS_ERR;
+  if (count != 0)
+    return MR_IN_USE;
+
   return MR_SUCCESS;
 }