Re: Numeric user names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Ed Stoner <ed(at)whsd(dot)k12(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Numeric user names
Date: 2004-10-19 06:33:08
Message-ID: 12300.1098167588@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Neil Conway <neilc(at)samurai(dot)com> writes:
> I don't know of an easy workaround. Why do you need numeric usernames?

There's always double-quoted identifiers:
create user "12345" with password ...

Considering that the SQL standard defines <authorization identifier>
as an <identifier>, I'm not sure why Ed is expecting that he should
be able to use a bare number as a user name.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-10-19 06:57:47 Re: Avoiding explicit addDataType calls for PostGIS
Previous Message Stephan Szabo 2004-10-19 06:02:21 Re: Numeric user names