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.
>
>
>
