Re: Suggestions for improving \conninfo output in v18 - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Suggestions for improving \conninfo output in v18
Date
Msg-id CAKFQuwasj8LyAg1VQ088fecb1ee8WfE-K2a7io380RB0+Tp67Q@mail.gmail.com
Whole thread Raw
In response to Suggestions for improving \conninfo output in v18  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
On Sunday, June 1, 2025, Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
In v18, the "Protocol Version" column shown by \conninfo reports only
the major version (e.g., 3). Wouldn't it be more helpful to show the full
version (e.g., 3.2) using PQfullProtocolVersion()? Since support for
protocol version 3.2 was introduced in v18, users may want to know
exactly which version the current session is using.

This seems like a probable oversight that should be corrected.
 

Also, I noticed that the "Client User" column reflects the user at
the time of connection, while the "Superuser" column reflects whether
the current user in the current execution context is a superuser.
This means the users referred to in these columns can differ.
It might be worth aligning this behavior, or at least noting the distinction
clearly in the documentation?

The behavior seems consistent with the reality of our protocol and libpq.  What did you have in mind for documentation changes?

David J.

pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Add AioUringCompletion in wait_event_names.txt and a safeguard in generate-wait_event_types.pl
Next
From: Paul Jungwirth
Date:
Subject: SQL:2011 Application Time Update & Delete