Horton

Re: Things I don't like about \du's "Attributes" column

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>
Cc: Jim Nasby <jim.nasby@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Date: 2024-01-23T02:30:29Z
Lists: pgsql-hackers 
On Sun, Jan 21, 2024 at 2:35 PM Pavel Luzanov <p.luzanov@postgrespro.ru>
wrote:

>                                   List of roles
>  Role name | Attributes  | Password? |      Valid until       | Connection limit
> -----------+-------------+-----------+------------------------+------------------
>  admin     | INHERIT     | no        |                        |               -1
>  alice     | SUPERUSER  +| yes       | infinity               |                5
>
> I think I'm in the minority on believing that these describe outputs
should not be beholden to internal implementation details.  But seeing a -1
in the limit column is just jarring to my sensibilities.  I suggest
displaying blank (not null, \pset should not influence this) if the
connection limit is "no limit", only showing positive numbers when there is
meaningful exceptional information for the user to absorb.

David J.