Reported by:

Date:

Description

At "Enter user's postgres ID or RETURN to use unix user ID:XXX --->" the "createuser" executable does not use the requested user's uid number by default when pressing . It aborts with "createuser: the postgres ID must be a number".

Fix

Apply this patch:

diff -c -r1.3 createuser.sh
*** 1.3 1995/05/02 01:33:21
--- createuser.sh       1995/05/11 20:01:03
***************
*** 129,134 ****
--- 129,135 ----
      do
        echo _fUnKy_DASH_N_sTuFf_ "Enter user's postgres ID$DEFMSG -> "_fUnKy_BACKSLASH_C_sTuFf_
        read SYSID
+       [ -z "$SYSID" ] && SYSID=$DEFSYSID;
        SYSIDISNUM=`echo $SYSID | egrep '^[0-9]+$'`
        if [ -z "$SYSIDISNUM" ]
        then
***************
*** 135,141 ****
                echo "$CMDNAME: the postgres ID must be a number"
                exit 1
        fi
-       [ -z "$SYSID" ] && SYSID=$DEFSYSID;
        QUERY='select usename from pg_user where usesysid = '"\"$SYSID\""'::int2'
        RES=`$MONITOR -TN -c "$QUERY" template1`
        if [ $? -ne 0 ]
--- 136,141 ----