Thread: BUG #8376: Doc update: CREATE ROLE

BUG #8376: Doc update: CREATE ROLE

From
bughunt@gluino.name
Date:
The following bug has been logged on the website:

Bug reference:      8376
Logged by:          David Tonhofer
Email address:      bughunt@gluino.name
PostgreSQL version: 9.2.4
Operating system:   Linux
Description:

At: http://www.postgresql.org/docs/9.2/static/sql-createrole.html


1) Description of how to set "ROLCATUPDATE" is missing (if there is such an
option)


2) The option 'VALID UNTIL' should mention:
   a) The special value 'infinity', which
      seems to be equal to NULL
   b) The fact that validity applies to
      the password and thus does not
      affect logins done by other means
      than passwords.

Re: BUG #8376: Doc update: CREATE ROLE

From
Bruce Momjian
Date:
On Thu, Aug  8, 2013 at 10:24:37AM +0000, bughunt@gluino.name wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8376
> Logged by:          David Tonhofer
> Email address:      bughunt@gluino.name
> PostgreSQL version: 9.2.4
> Operating system:   Linux
> Description:
>
> At: http://www.postgresql.org/docs/9.2/static/sql-createrole.html
>
>
> 1) Description of how to set "ROLCATUPDATE" is missing (if there is such an
> option)

Uh, that is one of those system catalog fields that is auto-populated
based on whether you are a super-user, and to change it you have to
update the system catalogs.  Should we mention that?

> 2) The option 'VALID UNTIL' should mention:
>    a) The special value 'infinity', which
>       seems to be equal to NULL

Well, infinity and NULL behave the same, but I am thinking we are best
to recommend NULL for its simplicity.

>    b) The fact that validity applies to
>       the password and thus does not
>       affect logins done by other means
>       than passwords.

Where did you see that was not clearly specified?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +