> From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 29 May 2006 18:16 > "Silvio Macedo" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster