Horton

Re: Psql meta-command conninfo+

Sami Imseih <samimseih@gmail.com>

View thread View on postgr.es
From: Sami Imseih <samimseih@gmail.com>
To: Maiquel Grassi <grassi@hotmail.com.br>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Hunaid Sohail <hunaidpgml@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, "David G. Johnston" <david.g.johnston@gmail.com>, Jim Jones <jim.jones@uni-muenster.de>, Tom Lane <tgl@sss.pgh.pa.us>, Nathan Bossart <nathandbossart@gmail.com>, "Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>, Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-02-21T19:54:17Z
Lists: pgsql-hackers 
> Maybe keeping track of 'role' via ParameterStatus messages is a good
> idea for reasons unrelated to this patch -- maybe it can be useful for
> applications to be aware of role changes -- but I'm not 100% sure about
> that, and in particular I'm not sure how heavy the protocol traffic is
> going to be if such messages are emitted every time you run a security
> invoker function or things like that

With the latest version of the patch, 'role' is not needed as
'session authorization' is not shown either [1].

The latest version LGTM.

Regards,

Sami Imseih
Amazon Web Services (AWS)

[1] https://www.postgresql.org/message-id/CAA5RZ0tbWopM83akPZ5M42V_RtyMTV8UfNUdE9LYw0YsPdOX5g%40mail.gmail.com

Commits

  1. psql: Change new \conninfo to use SSL instead of TLS

  2. Change \conninfo to use tabular format

  3. Update extension lookup routines to use the syscache

  4. Improve COPY TO performance when server and client encodings match

  5. doc: Remove superfluous bracket in synopsis

  6. Remove psql support for server versions preceding 9.2.