Re: BUG #2459: psql 8.1.4 vs 8.0.x behaves differently with tty / con / stdin recent fixes

> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 29 May 2006 18:16
> "Silvio Macedo" <smacedo(at)calmetric(dot)pt> writes:
> > I've been using stdin/stdout of psql on Windows to run a
> script, without
> > messing with "expect".
> > Before v8.1.4, one could include the password in the string
> fed to psql via
> > stdin to authenticate the connection.
> > With 8.1.4, it doesn't work.
>
> That's how it's been on Unix for a long time (/dev/tty is not
stdin),
> so I'd say this is a bug fix not a bug.
>
> regards, tom lane

Thanks Alvaro, Tom and Bruce for the quick replies. What an honour!
Regarding UNIX, I know - I helped a tiny bit the port of PGSql to
Linux Sparc64.;)

In this case, I think users upgrading from 8.0.x to 8.1. should be
warned.(think interfacing with old software, no source available,
"upgraded" to PGSql via messy console stub scripts)

Users uncomfortable with writing down the password on a PGPASSWORD
environment var or pgpass.conf, ___*on the machine running PSQL
client*___, seem to have no solution then... I know - something to ask
in pgsql-general.

Thanks again,

Silvio
calmetric.pt