Обсуждение: Suggestions for improving \conninfo output in v18
Hi, 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. 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? Regards, -- Fujii Masao NTT DATA Japan Corporation
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.