Re: Why no pg_has_role(..., 'ADMIN')?

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: Why no pg_has_role(..., 'ADMIN')?
Date: 2024-09-23 12:56:33
Message-ID: CAFCRh-9JFk3eUnGxx6dUjejKEN-LSb9RKSckz0ifUUtpQu+5rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 20, 2024 at 8:49 PM Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Fri, Sep 20, 2024 at 2:34 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2024-09-23 12:59:43 Re: Customize psql prompt to show current_role
Previous Message Dominique Devienne 2024-09-23 12:54:03 Re: Why no pg_has_role(..., 'ADMIN')?