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

PGP signature


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to