BUG #8376: Doc update: CREATE ROLE

Started by David Tonhoferover 12 years ago2 messagesbugs
Jump to latest
#1David Tonhofer
bughunt@gluino.name

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.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Bruce Momjian
bruce@momjian.us
In reply to: David Tonhofer (#1)
Re: BUG #8376: Doc update: CREATE ROLE

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. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs