| From: | Michiel Lange <michiel(at)minas(dot)demon(dot)nl> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug with usernames that are only numbers |
| Date: | 2003-01-28 21:27:37 |
| Message-ID: | 5.1.0.14.0.20030128222334.00b84f40@192.168.1.3 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-28 22:37:02 | Re: Bug in LIKE operator processing |
| Previous Message | Stephan Szabo | 2003-01-28 20:26:06 | Re: Bug in LIKE operator processing |