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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])