Valid role name (PostgreSQL 9.0.4)
| От | Grzegorz Szpetkowski |
|---|---|
| Тема | Valid role name (PostgreSQL 9.0.4) |
| Дата | |
| Msg-id | BANLkTinZOs1dqjzK3BoAnRVY+9_9wwHFcQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Valid role name (PostgreSQL 9.0.4)
|
| Список | pgsql-novice |
In standard postgres/main/5432 cluster I created new role (from
postgres account):
createuser -SRD user
psql -c "\du"
List of roles
Role name | Attributes | Member of
-----------+-----------------------------------+-----------
postgres | Superuser, Create role, Create DB | {}
user | | {}
Then I run:
psql -c "ALTER ROLE user CREATEDB"
ERROR: syntax error at or near "user"
LINE 1: ALTER ROLE user CREATEDB
^
After some searching I found that 'user' is reserved PostgreSQL keyword
(http://www.postgresql.org/docs/9.0/interactive/sql-keywords-appendix.html),
but I think that PostgreSQL should deny my request to create role with
reserved keyword. What do you think ? I mean something like:
createuser -SRD user
ERROR: illegal name
Thanks,
Grzegorz Sz.
В списке pgsql-novice по дате отправления: