Re: Cannot connect to the database (PG 7.3)

Hmmm, I tried it (7.3.1) and it seems to work fine. Perhaps something else is
going on - pg_hba.conf setup??:

steve=# create user "12345";
CREATE USER

steve@betelgeuse:~> psql -h betelgeuse -U 12345 steve
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

steve=>

Cheers,
Steve


On Tuesday 28 January 2003 1:43 pm, Tom Lane wrote:
> Michiel Lange <michiel@minas.demon.nl> writes:
> > It is, somehow, not possible to connect as a user which name is
> > completely numeric.
>
> I muttered "nonsense!" to myself, but darned if you're not right:
>
> regression=# create user "12345";
> CREATE USER
> regression=# \q
> $ psql -U 12345 regression
> psql: FATAL:  SET SESSION AUTHORIZATION: permission denied
>
> Will look into it.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org