Re: Psql meta-command conninfo+
| От | Alvaro Herrera | 
|---|---|
| Тема | Re: Psql meta-command conninfo+ | 
| Дата | |
| Msg-id | 202404011622.eppdne4344lo@alvherre.pgsql обсуждение исходный текст  | 
		
| Ответ на | RE: Psql meta-command conninfo+ (Maiquel Grassi <grassi@hotmail.com.br>) | 
| Ответы | 
                	
            		Re: Psql meta-command conninfo+
            		
            		 RE: Psql meta-command conninfo+  | 
		
| Список | pgsql-hackers | 
Hello
Yeah, that's what I meant about the translations, thanks.
Two more comments,
- You don't need a two-level conditional here
    if (pset.sversion >= 90500)
    {
        if (pset.sversion < 140000)
            appendPQExpBuffer(&buf,
                              "  ssl.ssl AS \"%s\",\n"
                              "  ssl.version AS \"%s\",\n"
                              "  ssl.cipher AS \"%s\",\n"
                              "  ssl.compression AS \"%s\",\n",
                              _("SSL Connection"),
                              _("SSL Protocol"),
                              _("SSL Cipher"),
                              _("SSL Compression"));
        if (pset.sversion >= 140000)
            appendPQExpBuffer(&buf,
                              "  ssl.ssl AS \"%s\",\n"
                              "  ssl.version AS \"%s\",\n"
                              "  ssl.cipher AS \"%s\",\n"
                              "  NULL AS \"%s\",\n",
                              _("SSL Connection"),
                              _("SSL Protocol"),
                              _("SSL Cipher"),
                              _("SSL Compression"));
    }
    else
        appendPQExpBuffer(&buf,
                          "  NULL AS \"%s\",\n"
                          "  NULL AS \"%s\",\n"
                          "  NULL AS \"%s\",\n"
                          "  NULL AS \"%s\",\n",
                          _("SSL Connection"),
                          _("SSL Protocol"),
                          _("SSL Cipher"),
                          _("SSL Compression"));
  Instead you can just do something like
  if (pset.version >= 140000)
    one thing;
  else if (pset.version > 90500)
    second thing;
  else
    third thing;
  This also appears where you add the GSSAPI columns; and it's also in the
  final part where you append the FROM clause, though it looks a bit
  different there.
- You have three lines to output a semicolon at the end of the query
  based on version number.  Remove the first two, and just have a final
  one where the semicolon is added unconditionally.
- I don't think one <para> for each item in the docs is reasonable.
  There's too much vertical whitespace in the output.  Maybe do this
  instead:
        [...]
        database connection. When <literal>+</literal> is appended,
        more details about the connection are displayed in table
        format:
        <simplelist>
         <member>
          <term>Database:</term> The name of the current
          database on this connection.
         </member>
         <member>
          <term>Authenticated User:</term> The authenticated
          user at the time of psql connection with the server.
         </member>
     
         ...
        </simplelist>
- This text is wrong to start with "Returns the":
    System User: Returns the authentication method and the identity (if
    any) that the user presented during the authentication cycle before
    they were assigned a database role. It is represented as
    auth_method:identity or NULL if the user has not been authenticated.
  That minor point aside, I disagree with Sami about repeating the docs
  for system_user() here.  I would just say "The authentication data
  provided for this connection; see the function system_user() for more
  details." with a link to the appropriate section of the docs.  Making
  us edit this doc if we ever modify the behavior of the function is not
  great.
-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"We're here to devour each other alive"            (Hobbes)
		
	В списке pgsql-hackers по дате отправления: