On Wed, 2004-10-13 at 06:31, Ed Stoner wrote:
> I am unable to use the "CREATE USER" command with numeric user names
> (i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
> a problem somewhere with how I have things configured? Is there are
> workaround?
A username is an identifier; per the docs, "SQL identifiers and key
words must begin with a letter (a-z, but also letters with diacritical
marks and non-Latin letters) or an underscore (_). Subsequent characters
in an identifier or key word can be letters, underscores, digits (0-9),
or dollar signs ($)." So it's a limitation.
I don't know of an easy workaround. Why do you need numeric usernames?
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
