Create numeric user returns syntax error at or near "XXXX"

Products

• Services Suite

Issue/Introduction

Symptoms:
When trying to create a user with only numbers, a syntax error is returned:

Error Message

gpadmin=# create user 1234 with login password 'password' ;
ERROR:  syntax error at or near "1234"
LINE 1: create user 1234 with login password 'password' ;             

Environment

Cause

Numeric only usernames are not allowed in HDB.

Resolution

Prefix some characters to your user name. For example:

gpadmin=# create user u_1234 with login password 'password' ;
NOTICE:  resource queue required -- using default resource queue "pg_default"
CREATE ROLE
gpadmin=#