Username with a hyphen character (grant failing?) - Mailing list pgsql-general

From Sean Chittenden
Subject Username with a hyphen character (grant failing?)
Date
Msg-id 20010525055923.B36679@rand.tgd.net
Whole thread Raw
Responses Re: Username with a hyphen character (grant failing?)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

Attachment

pgsql-general by date:

Previous
From: Patrik Järnefelt
Date:
Subject: JDBC
Next
From: zilch@home.se
Date:
Subject: Transactions and *ABORT STATE*