MIME-Version: 1.0
References: <164978692927.1276557.9862487759615827386@wrigleys.postgresql.org>
 <910015.1649791788@sss.pgh.pa.us>
In-Reply-To: <910015.1649791788@sss.pgh.pa.us>
From: Keith Wanta <wantakeith@gmail.com>
Date: Tue, 12 Apr 2022 14:36:03 -0500
Message-ID: 
 <CAH6-sxA2qpOnf1-up1u7z106Xc-snG-Exf35Cg=niHB=N6-GAQ@mail.gmail.com>
Subject: Re: role attributes are missing from this page
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: wantakeith+160@gmail.com, pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009f959b05dc7a2c72"
Archived-At: 
 <https://www.postgresql.org/message-id/CAH6-sxA2qpOnf1-up1u7z106Xc-snG-Exf35Cg%3DniHB%3DN6-GAQ%40mail.gmail.com>
Precedence: bulk

--0000000000009f959b05dc7a2c72
Content-Type: text/plain; charset="UTF-8"

Thanks!  Because I'm getting oid, I might need glasses.

On Tue, Apr 12, 2022 at 2:29 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> PG Doc comments form <noreply@postgresql.org> 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
>

--0000000000009f959b05dc7a2c72
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks!=C2=A0 Because I&#39;m getting <font size=3D"6">oid=
</font>, I might need glasses.=C2=A0=C2=A0</div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Apr 12, 2022 at 2:29 PM T=
om Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">PG Doc co=
mments form &lt;<a href=3D"mailto:noreply@postgresql.org" target=3D"_blank"=
>noreply@postgresql.org</a>&gt; writes:<br>
&gt; Issue #1:<br>
&gt; &quot;old&quot; is a keyword, but I cannot query the old column explic=
itely with<br>
&gt; surrounding quotes.<br>
&gt; SELECT &quot;old&quot; FROM pg_roles;<br>
<br>
Look closer.=C2=A0 That column is &quot;oid&quot; not &quot;old&quot;.<br>
<br>
&gt; Issue #2:<br>
&gt; You do not have ALL role attributes documented on this page.=C2=A0 Ple=
ase add and<br>
&gt; document the missing role attributes.<br>
&gt; <a href=3D"https://www.postgresql.org/docs/current/role-attributes.htm=
l" rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/cur=
rent/role-attributes.html</a><br>
<br>
AFAICS this page is merely trying to document the role properties that<br>
can reasonably be considered to be kinds of privileges.=C2=A0 I don&#39;t h=
ave<br>
a problem with it not mentioning role name or password, for example.<br>
In any case, if you want a full list of what is in the pg_roles view,<br>
the place to look is under the system views documentation:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/view-pg-roles.html" rel=
=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current/v=
iew-pg-roles.html</a><br>
<br>
role-attributes.html is not intended to be a substitute for that.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--0000000000009f959b05dc7a2c72--