Peter Eisentraut <pete...@gmx.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers