Bug with usernames that are only numbers - Mailing list pgsql-bugs

From Michiel Lange
Subject Bug with usernames that are only numbers
Date
Msg-id 5.1.0.14.0.20030128222334.00b84f40@192.168.1.3
Whole thread Raw
List pgsql-bugs
Hello people,

I am sorry for bothering, but lately I ran into a bug, and it took me
really some time to find it out. However the problem is this:

It is possible to create a user of which the Username consists only of
numbers. (sorry for this long and descriptive english)
e.g.: CREATE USER "12345" WITH ENCRYPTED PASSWORD 'ohjoy';

However, this user will not be able to connect. At least not with 'psql',
but I had trouble trying out with PHP as well, so I reckon this happens all
the time.

neither of these options will work:
psql -U 12345
psql -U "12345"
psql -U '12345'

Of course there are workarounds, but it is not right that I can create
users that cannot connect...

Michiel

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [CHECKER] 9 potential out-of-bounds array access errors
Next
From: Yichen Xie
Date:
Subject: Re: [CHECKER] 9 potential out-of-bounds array access errors