Feedback-ID: ia2694551:Fastmail
Date: Thu, 4 Apr 2024 17:53:37 +0200
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Maiquel Grassi <grassi@hotmail.com.br>, 
	"Imseih (AWS), Sami" <simseih@amazon.com>, Nathan Bossart <nathandbossart@gmail.com>, 
	Jim Jones <jim.jones@uni-muenster.de>, Pavel Luzanov <p.luzanov@postgrespro.ru>, 
	Erik Wienhold <ewie@ewie.name>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Psql meta-command conninfo+
Message-ID: <202404041553.srcj7n3auv65@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <f4fc729d-7903-4d58-995d-6cd146049992@eisentraut.org>
Archived-At: <https://www.postgresql.org/message-id/202404041553.srcj7n3auv65%40alvherre.pgsql>
Precedence: bulk

On 2024-Apr-04, Peter Eisentraut wrote:

> But I don't really see the point of this.  The information you are querying
> is already available in various system views.  This proposal is just a
> shorthand for a collection of various random things some people like to see.
> Like, by what reason is application name included as connection info?  Why
> not any other session settings?  What about long-term maintenance: By what
> logic should things be added to this?

Usability is precisely the point.  You could also claim that we don't
need \dconfig, since you could get the same thing by querying
pg_settings for non-default settings.  But \dconfig is very handy.  I
expect \conninfo+ to be equally useful.  We don't give up command
history just on the grounds that you can obtain the same effect by
retyping the command.


I'm not sure to what extent is it useful to make a distinction between
the values that the client knows from those that the server knows.  If
it is, then we can redefine \conninfo+ to use the client values.

The point about application_name is a valid one.  I guess it's there
because it's commonly given from the client side rather than being set
server-side, even though it's still a GUC.  Arguably we could remove it
from \conninfo+, and claim that nothing that shows up in \dconfig should
also appear in \conninfo+.  Then users should get in the habit of using
both to obtain a full picture.  This sounds to me a very good compromise
actually.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
Tom: There seems to be something broken here.
Teodor: I'm in sackcloth and ashes...  Fixed.
                               http://postgr.es/m/482D1632.8010507@sigaev.ru