reserved role names

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: reserved role names
Date: 2016-07-05 18:06:38
Message-ID: 577BF72E.8070901@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2016-07-05 18:12:10 Re: reserved role names
Previous Message Peter Geoghegan 2016-07-05 17:58:17 Re: Parallel query and temp_file_limit