Re: BUG #4040: psql should provide option to not prompt for password

Tom Lane [2008-03-17 10:48 -0400]:
> Martin Pitt  writes:
> >  		if (PQstatus(pset.db) == CONNECTION_BAD &&
> >  			PQconnectionNeedsPassword(pset.db) &&
> > -			password == NULL &&
> > +			password == NULL && !getenv("PGPASSWORD") &&
> >  			!feof(stdin))
> >  		{
> >  			PQfinish(pset.db);
> 
> What exactly do you think that accomplishes?  AFAICS
> PQconnectionNeedsPassword can't possibly return true if there was a
> password available from PGPASSWORD (regardless of whether it was
> correct or not).

I don't claim to understand the complete code behind
PQconnectionNeedsPassword(). I just found that in at least 8.3RC1,
this did return True if pg_hba.conf set password authentication and
none was provided. I tried every trick that came into my mind,
redirecting stdin, using PGPASSWORD, and I think even a fake empty
.pgpass file, nothing worked.

Martin
-- 
Martin Pitt                        | http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)