Username with a hyphen character (grant failing?)

From: Sean Chittenden <sean-pgsql-general(at)chittenden(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Username with a hyphen character (grant failing?)
Date: 2001-05-25 12:59:24
Message-ID: 20010525055923.B36679@rand.tgd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rene Pijlman 2001-05-25 13:01:29 Re: JDBC
Previous Message Patrik Järnefelt 2001-05-25 10:32:00 JDBC