2023年10月13日(金) 20:47 Luca Ferrari <fluca1978@xxxxxxxxx>: > > 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=0a1d2a7df852f16c452eef8a83003943125162c7 and also noted in the release notes: https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL Regards Ian Barwick
