Обсуждение: reserved role names

Hey,

For grins while writing up an example on RLS for a client I tried the 
following:

policy=# create role insert;
CREATE ROLE

policy=# create role select;
ERROR:  syntax error at or near "select"
LINE 1: create role select;                    ^
policy=# create role delete;
CREATE ROLE

Is it intentional that insert and delete are allowed and select is not 
or is it an oversight?

Sincerely,

JD

-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.

>>>>> "Joshua" == Joshua D Drake <jd@commandprompt.com> writes:
Joshua> Is it intentional that insert and delete are allowed and selectJoshua> is not or is it an oversight?

Just an artifact of SELECT being fully reserved (needed for (SELECT ...)
syntax to work right) while INSERT and DELETE are unreserved.

-- 
Andrew (irc:RhodiumToad)