Postgres Pro
Downloads
Home   >   mailing lists

Re: Why no pg_has_role(..., 'ADMIN')? - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Why no pg_has_role(..., 'ADMIN')?
Date
Msg-id CAFCRh-9JFk3eUnGxx6dUjejKEN-LSb9RKSckz0ifUUtpQu+5rA@mail.gmail.com
Whole thread Raw
In response to Re: Why no pg_has_role(..., 'ADMIN')?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-general
Tree view 
On Fri, Sep 20, 2024 at 8:49 PM Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, Sep 20, 2024 at 2:34 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > 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

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Why no pg_has_role(..., 'ADMIN')?
Next
From: Dominique Devienne
Date:
Subject: Re: Customize psql prompt to show current_role