Re: Things I don't like about \du's "Attributes" column - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Things I don't like about \du's "Attributes" column
Date
Msg-id CAKFQuwY0rYk+7ryvxi=9dwEXRqD1Xwwwmptr=vnDbXKmHEym9w@mail.gmail.com
Whole thread Raw
In response to Re: Things I don't like about \du's "Attributes" column  (Pavel Luzanov <p.luzanov@postgrespro.ru>)
List 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.

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Things I don't like about \du's "Attributes" column
Next
From: Nathan Bossart
Date:
Subject: Re: introduce dynamic shared memory registry