Valid role name (PostgreSQL 9.0.4)

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.

Responses

Browse pgsql-novice by date

  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)