From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Cc: | wantakeith+160(at)gmail(dot)com |
Subject: | role attributes are missing from this page |
Date: | 2022-04-12 18:08:49 |
Message-ID: | 164978692927.1276557.9862487759615827386@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/role-attributes.html
Description:
Issue #1:
"old" is a keyword, but I cannot query the old column explicitely with
surrounding quotes.
SELECT "old" FROM pg_roles;
Issue #2:
You do not have ALL role attributes documented on this page. Please add and
document the missing role attributes.
https://www.postgresql.org/docs/current/role-attributes.html
This is a list of all role attributes:
SELECT
rolname,rolsuper,rolinherit,rolcreaterole,rolcreatedb,rolcanlogin,rolreplication,rolconnlimit,rolpassword,rolvaliduntil,rolbypassrls,rolconfig,"old"
FROM pg_roles;
These role attributes are documented:
SELECT
rolcanlogin,rolsuper,rolcreatedb,rolcreaterole,rolreplication,rolpassword
FROM pg_roles;
These role attributes are NOT documented:
SELECT
rolname,rolsuper,rolinherit,rolconnlimit,,rolvaliduntil,rolbypassrls,rolconfig,"old"
FROM pg_roles;
SELECT "old" FROM pg_roles;
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2022-04-12 18:43:42 | "GIN and GiST Index Types" page is about usage in full text search, but looks general purpose |
Previous Message | Sebastien Flaesch | 2022-04-12 14:48:03 | Re: Missing example for SAVEPOINT using the same savepoint name |