From: | Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Valid role name (PostgreSQL 9.0.4) |
Date: | 2011-04-08 03:21:00 |
Message-ID: | BANLkTinZOs1dqjzK3BoAnRVY+9_9wwHFcQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Kupershmidt | 2011-04-08 03:29:22 | Re: Superuser accout (PostgreSQL 9.0.4) |
Previous Message | Grzegorz Szpetkowski | 2011-04-08 03:15:14 | Superuser accout (PostgreSQL 9.0.4) |