Trying to GRANT privileges on a newly-created database
| От | Lou Picciano |
|---|---|
| Тема | Trying to GRANT privileges on a newly-created database |
| Дата | |
| Msg-id | 1720764182.4921461272841175665.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net обсуждение исходный текст |
| Ответы |
Re: Trying to GRANT privileges on a newly-created database
|
| Список | pgsql-testers |
[TEST REPORT]
[Release]: 8.5alpha2
[Test Type]: psql CLI
[Test]: Trying to GRANT privileges on a newly-created database
[Platform]: Solaris SPARC 4u (E450)
[Parameters]: Trying to GRANT privileges on a newly-created database. db name in lower case.
[Failure]: yes
[Results]:
# CREATE DATABASE dbname;
# GRANT ALL ON dbname TO role;
ERROR: relation "dbname" does not exist
Please note this database is created in lower case; it has not been renamed from upper.
# GRANT ALL ON dbname TO role; - produces the same error.
[Comments]: We've seen that users have this problem with mixed-case object names, and must use quotes. Our example names have always been in lowercase - have not bee rename, and we've tried commands both without tnd with quotes! Have we somehow corrupted this cluster? Am seeing other strange behavior related to simple commands.
В списке pgsql-testers по дате отправления: