Re: username length character limits?

tried it with two underscores and short name:
    H1q2W_web_user

with only one underscore and a long name:
    H1q2W3e4R5t6Y7u8Iweb_user

with only oneunderscore and a short name:
    H1q2Wweb_user

with no underscore and a long name:
    H1q2W3e4R5t6Y7u8Iwebuser

with no underschore and a short name:
    H1q2W3webuser

--------------------------------------------------------------------
NONE OF THESE NAMES WORK AS USER NAMES WITH THE PASSWORD 'password'.
--------------------------------------------------------------------

I have no idea why.

Where does it say what is the legal:

    length
    characters
    character set (?)

for user names?

one underscore and a short name.

Dennis Gearon wrote:

> Please CC me:
>
> If I create the user 'web_user'
> with password 'password'
> I can connect using 'psql' just fine.
>
> If I create the user 'D1Khb2g5m7FGk_web_user'
> with password 'password'
> I CANNOT connect using 'psql', I get authentication error.
>
> -----------------------------
> ANYONE have any ideas why?
> -----------------------------
>
> PG_VERSION says it's 7.3. I don't know how to find out any more accurately the subversion of that.
>
>
>