public inbox for [email protected]
help / color / mirror / Atom feedFrom: Keith Wanta <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: role attributes are missing from this page
Date: Tue, 12 Apr 2022 14:36:03 -0500
Message-ID: <CAH6-sxA2qpOnf1-up1u7z106Xc-snG-Exf35Cg=niHB=N6-GAQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[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
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: role attributes are missing from this page
In-Reply-To: <CAH6-sxA2qpOnf1-up1u7z106Xc-snG-Exf35Cg=niHB=N6-GAQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox