MIME-Version: 1.0
References: <CAFCRh-8JNEy+dV4SXFOrWca50u+d=--TO4cq=+ac1oBtfJy4AA@mail.gmail.com>
 <42cf78d42a376bf05ca9f5776ad29edc30e784d5.camel@cybertec.at>
 <CA+TgmobvCGAHPZxX1rNgUb1cGcmD5e8ESGVSL=OyVqDYCAV3EQ@mail.gmail.com>
 <2468702.1726856198@sss.pgh.pa.us> <2470834.1726857267@sss.pgh.pa.us> <CA+TgmoZ44MXgcgLwyPJJ8kypRezOJ=BOUsAPs9Q=rJGKQQLCwA@mail.gmail.com>
In-Reply-To: <CA+TgmoZ44MXgcgLwyPJJ8kypRezOJ=BOUsAPs9Q=rJGKQQLCwA@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 23 Sep 2024 14:56:33 +0200
Message-ID: <CAFCRh-9JFk3eUnGxx6dUjejKEN-LSb9RKSckz0ifUUtpQu+5rA@mail.gmail.com>
Subject: Re: Why no pg_has_role(..., 'ADMIN')?
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>, 
	pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-9JFk3eUnGxx6dUjejKEN-LSb9RKSckz0ifUUtpQu%2B5rA%40mail.gmail.com>
Precedence: bulk

On Fri, Sep 20, 2024 at 8:49=E2=80=AFPM Robert Haas <robertmhaas@gmail.com>=
 wrote:
> On Fri, Sep 20, 2024 at 2:34=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrot=
e:
> > I'm now inclined to add wording within the pg_has_role entry
> I don't have an opinion about the details, but +1 for documenting it

+1 as well. Especially since I now recall, in hindsight,
about reading the *distant* mention about 'WITH ADMIN OPTION'
that could be added, but still forgot about it when reading only the
*immediate* doc on pg_has_role(). My $0.02. --DD