Re: BUG #16486: Prompted password is ignored when password specified in connection string - Mailing list pgsql-bugs

From Oleksandr Shulgin
Subject Re: BUG #16486: Prompted password is ignored when password specified in connection string
Date
Msg-id CACACo5RDv3ahJ_whCmMRRqc6Y6C5XVStJ-kC5JJgiZ5KM7TRFA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
On Tue, Sep 1, 2020 at 10:38 PM Bruce Momjian <bruce@momjian.us> wrote:

I used a later version of Tom's patch to add documentation of how
connection strings can override command-line options, plus it has the
password description improvements.

I would like to apply this to all supported versions.

Not related to the proposed change, this sentence is the same before and after, but makes me wonder:

> However, <application>psql</application>
        will waste a connection attempt finding out that the server wants a
        password.  In some cases it is worth typing <option>-W</option> to avoid
        the extra connection attempt.

AFAIK, there is nothing in the protocol that forces psql to make an extra connection attempt.  If libpq provided a means to pass a password-prompt callback, no extra connection would be needed I think?

Regards,
--
Alex

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #16594: DROP INDEX CONCURRENTLY fails on partitioned table with a non helpful error message.
Next
From: Matthias van de Meent
Date:
Subject: Re: BUG #16586: deduplicate_items=true can be configured for numeric indexes