Username with a hyphen character (grant failing?)

Поиск
Список
Период
Сортировка
От Sean Chittenden
Тема Username with a hyphen character (grant failing?)
Дата
Msg-id 20010525055923.B36679@rand.tgd.net
обсуждение исходный текст
Ответы Re: Username with a hyphen character (grant failing?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
    What's the scoop with username constraints?  I setup and
created a user with a '-' character in the middle (worked).  When I
tried to grant the new user some privs, grant choked on the '-' w/ a
parse error.

foo=# GRANT SELECT ON test TO www-foo;
ERROR:  parser: parse error at or near "-"
foo=# update pg_shadow set usename = 'www_foo' where usename = 'www-foo';
UPDATE 1
foo=# GRANT SELECT ON maildir TO www_foo;
CHANGE

    Did I miss a page someplace that said I couldn't use a '-' in
a username, or is this a bug? -sc


--
Sean Chittenden

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Patrik Järnefelt
Дата:
Сообщение: JDBC
Следующее
От: zilch@home.se
Дата:
Сообщение: Transactions and *ABORT STATE*