public inbox for [email protected]help / color / mirror / Atom feed
role attributes are missing from this page 3+ messages / 3 participants [nested] [flat]
* role attributes are missing from this page @ 2022-04-12 18:08 PG Doc comments form <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: PG Doc comments form @ 2022-04-12 18:08 UTC (permalink / raw) To: [email protected]; +Cc: [email protected] 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; ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: role attributes are missing from this page @ 2022-04-12 19:29 Tom Lane <[email protected]> parent: PG Doc comments form <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2022-04-12 19:29 UTC (permalink / raw) To: [email protected]; +Cc: [email protected] PG Doc comments form <[email protected]> writes: > Issue #1: > "old" is a keyword, but I cannot query the old column explicitely with > surrounding quotes. > SELECT "old" FROM pg_roles; Look closer. That column is "oid" not "old". > 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 AFAICS this page is merely trying to document the role properties that can reasonably be considered to be kinds of privileges. I don't have a problem with it not mentioning role name or password, for example. In any case, if you want a full list of what is in the pg_roles view, the place to look is under the system views documentation: https://www.postgresql.org/docs/current/view-pg-roles.html role-attributes.html is not intended to be a substitute for that. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: role attributes are missing from this page @ 2022-04-12 19:36 Keith Wanta <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Keith Wanta @ 2022-04-12 19:36 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected]; [email protected] Thanks! Because I'm getting oid, I might need glasses. On Tue, Apr 12, 2022 at 2:29 PM Tom Lane <[email protected]> wrote: > PG Doc comments form <[email protected]> writes: > > Issue #1: > > "old" is a keyword, but I cannot query the old column explicitely with > > surrounding quotes. > > SELECT "old" FROM pg_roles; > > Look closer. That column is "oid" not "old". > > > 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 > > AFAICS this page is merely trying to document the role properties that > can reasonably be considered to be kinds of privileges. I don't have > a problem with it not mentioning role name or password, for example. > In any case, if you want a full list of what is in the pg_roles view, > the place to look is under the system views documentation: > > https://www.postgresql.org/docs/current/view-pg-roles.html > > role-attributes.html is not intended to be a substitute for that. > > regards, tom lane > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-04-12 19:36 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-04-12 18:08 role attributes are missing from this page PG Doc comments form <[email protected]> 2022-04-12 19:29 ` Tom Lane <[email protected]> 2022-04-12 19:36 ` Keith Wanta <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox