Re: Password prompting business

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> The feof(stdin) test is there from a time when the prompt when to stdout
> and the input came from stdin. Now it would usually not have any effect
> unless the program reads from stdin before connecting to the database,
> which doesn't happen, as far as I can tell.

> Unless I'm reading this wrong, we should probably remove this.

+1

> Anyway, a way to prevent a password prompt would still be useful. This
> should then be applicable to all client tools. I can imagine that we
> either add a command-line option (-w would mirror -W well) or do this
> automatically when stdin and/or stdout is not a terminal. I'm not sure
> if the latter can be made to work safely, though.

The entire point of the current arrangement is that it works when stdin
or stdout is not the terminal (eg, you've got psql in a pipe). So I
don't think you can make any changes on that basis without breaking more
use-cases than you solve.

Of the two use-cases mentioned in the messages you link to, I don't find
the first one convincing (what is actually wanted there is a "pg_ping"
utility); but the tab-completion-support example does seem like a case
where failure is preferable to issuing a password prompt. And there is
not really any good way for psql itself to distinguish this from
ordinary pipe cases. So a -w switch is probably the right answer.

regards, tom lane