Re: Remove duplicates of membership from results of \du

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Shinya Kato <Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Remove duplicates of membership from results of \du
Date: 2023-05-06 17:52:41
Message-ID: CAKFQuwYQwJzrnv6YbUh6-1_47dxX4sfkGTgtZ3wN7+Sdr-doBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, May 6, 2023 at 6:37 AM Shinya Kato <Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com>
wrote:

> Hi, hackers
>
> When executing \du, you can see duplicates of the same role in 'member of'.
> This happens when admin | inherit | set options are granted by another
> role.
>

There is already an ongoing patch discussing the needed changes to psql \du
because of this change in tracking membership grant attributes.

https://www.postgresql.org/message-id/flat/b9be2d0e-a9bc-0a30-492f-a4f68e4f7740%40postgrespro.ru

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alena Rybakina 2023-05-06 20:05:04 Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)
Previous Message Melanie Plageman 2023-05-06 17:30:39 Re: pg_stat_io not tracking smgrwriteback() is confusing