pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql \du no more showing "member of" column
7+ messages / 6 participants
[nested] [flat]
Commits from this thread:
2023-10-18 418d6b4430 doc: PG 16 relnotes: fix spelling error
* psql \du no more showing "member of" column
@ 2023-10-13 11:39 Luca Ferrari <fluca1978@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Luca Ferrari @ 2023-10-13 11:39 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
Hi all,
in version 16 psql does not show anymore the "member of" group
information when showing users with \du.
The query (still working fine) in previous versions was:
SELECT r.rolname, r.rolsuper, r.rolinherit,
r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
r.rolconnlimit, r.rolvaliduntil,
ARRAY(SELECT b.rolname
FROM pg_catalog.pg_auth_members m
JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
WHERE m.member = r.oid) as memberof
, r.rolreplication
, r.rolbypassrls
FROM pg_catalog.pg_roles r
WHERE r.rolname !~ '^pg_'
ORDER BY 1;
while now it is:
SELECT r.rolname, r.rolsuper, r.rolinherit,
r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
r.rolconnlimit, r.rolvaliduntil
, r.rolreplication
, r.rolbypassrls
FROM pg_catalog.pg_roles r
WHERE r.rolname !~ '^pg_'
ORDER BY 1;
at least, as it is shown by `psql -E`.
I wonder why this information has been removed, I'm not able to find
this in the documentation.
Thanks,
Luca
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-13 13:04 hubert depesz lubaczewski <depesz@depesz.com>
parent: Luca Ferrari <fluca1978@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: hubert depesz lubaczewski @ 2023-10-13 13:04 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:
> at least, as it is shown by `psql -E`.
> I wonder why this information has been removed, I'm not able to find
> this in the documentation.
Release notes show:
https://why-upgrade.depesz.com/show?from=15.4&to=16&keywords=%5Cdu
> Add psql command \drg to show role membership details (Pavel Luzanov)
> The Member of output column has been removed from \du and \dg because this new command displays this informaion in more detail.
Best regards,
depesz
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-13 13:06 Ian Lawrence Barwick <barwick@gmail.com>
parent: Luca Ferrari <fluca1978@gmail.com>
1 sibling, 2 replies; 7+ messages in thread
From: Ian Lawrence Barwick @ 2023-10-13 13:06 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
2023年10月13日(金) 20:47 Luca Ferrari <fluca1978@gmail.com>:
>
> Hi all,
> in version 16 psql does not show anymore the "member of" group
> information when showing users with \du.
>
> The query (still working fine) in previous versions was:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
> r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
> r.rolconnlimit, r.rolvaliduntil,
> ARRAY(SELECT b.rolname
> FROM pg_catalog.pg_auth_members m
> JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
> WHERE m.member = r.oid) as memberof
> , r.rolreplication
> , r.rolbypassrls
> FROM pg_catalog.pg_roles r
> WHERE r.rolname !~ '^pg_'
> ORDER BY 1;
>
>
> while now it is:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
> r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
> r.rolconnlimit, r.rolvaliduntil
> , r.rolreplication
> , r.rolbypassrls
> FROM pg_catalog.pg_roles r
> WHERE r.rolname !~ '^pg_'
> ORDER BY 1;
>
>
> at least, as it is shown by `psql -E`.
> I wonder why this information has been removed, I'm not able to find
> this in the documentation.
FWIW the explanation is in commit 0a1d2a7df8:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=0a1d2a7df852f16c452eef8a8300394312516...
and also noted in the release notes:
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
Regards
Ian Barwick
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-13 13:51 Luca Ferrari <fluca1978@gmail.com>
parent: hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 0 replies; 7+ messages in thread
From: Luca Ferrari @ 2023-10-13 13:51 UTC (permalink / raw)
To: depesz@depesz.com; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
On Fri, Oct 13, 2023 at 3:04 PM hubert depesz lubaczewski
<depesz@depesz.com> wrote:
>
> On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:
> > at least, as it is shown by `psql -E`.
> > I wonder why this information has been removed, I'm not able to find
> > this in the documentation.
>
> Release notes show:
>
> https://why-upgrade.depesz.com/show?from=15.4&to=16&keywords=%5Cdu
Thanks, I totally missed.
Luca
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-13 15:45 Lele Gaifax <lele@metapensiero.it>
parent: Ian Lawrence Barwick <barwick@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Lele Gaifax @ 2023-10-13 15:45 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
Ian Lawrence Barwick <barwick@gmail.com> writes:
> and also noted in the release notes:
>
> https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
FWIW, I noticed a small typo in the relevant entry: s/informaion/information/
ciao, lele.
--
nickname: Lele Gaifax | Dire che Emacs è "conveniente" è come
real: Emanuele Gaifas | etichettare l'ossigeno come "utile"
lele@etour.tn.it | -- Rens Troost
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-13 20:54 Pavel Luzanov <p.luzanov@postgrespro.ru>
parent: Ian Lawrence Barwick <barwick@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Pavel Luzanov @ 2023-10-13 20:54 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Hi,
On 13.10.2023 16:06, Ian Lawrence Barwick wrote:
> 2023年10月13日(金) 20:47 Luca Ferrari <fluca1978@gmail.com>:
>> Hi all,
>> in version 16 psql does not show anymore the "member of" group
>> information when showing users with \du.
>> FWIW the explanation is in commit 0a1d2a7df8:
>>
>> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=0a1d2a7df852f16c452eef8a8300394312516...
>>
>> and also noted in the release notes:
>>
>> https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
Some explanation can be found at the beginning of this article:
https://postgrespro.com/blog/pgsql/5970285
--
Pavel Luzanov
Postgres Professional: https://postgrespro.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: psql \du no more showing "member of" column
@ 2023-10-18 17:40 Bruce Momjian <bruce@momjian.us>
parent: Lele Gaifax <lele@metapensiero.it>
0 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2023-10-18 17:40 UTC (permalink / raw)
To: Lele Gaifax <lele@metapensiero.it>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
On Fri, Oct 13, 2023 at 05:45:35PM +0200, Lele Gaifax wrote:
> Ian Lawrence Barwick <barwick@gmail.com> writes:
>
> > and also noted in the release notes:
> >
> > https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
>
> FWIW, I noticed a small typo in the relevant entry: s/informaion/information/
>
> ciao, lele.
Thanks, fix applied.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-10-18 17:40 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-13 11:39 psql \du no more showing "member of" column Luca Ferrari <fluca1978@gmail.com>
2023-10-13 13:04 ` hubert depesz lubaczewski <depesz@depesz.com>
2023-10-13 13:51 ` Luca Ferrari <fluca1978@gmail.com>
2023-10-13 13:06 ` Ian Lawrence Barwick <barwick@gmail.com>
2023-10-13 15:45 ` Lele Gaifax <lele@metapensiero.it>
2023-10-18 17:40 ` Bruce Momjian <bruce@momjian.us>
2023-10-13 20:54 ` Pavel Luzanov <p.luzanov@postgrespro.ru>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox