Shouldn't .pgpass work with anything which uses libpq? - Mailing list pgsql-interfaces

From ljb
Subject Shouldn't .pgpass work with anything which uses libpq?
Date
Msg-id auobuv$lc0$1@news.hub.org
Whole thread Raw
Responses Re: Shouldn't .pgpass work with anything which uses libpq?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Shouldn't .pgpass work with anything which uses libpq?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-interfaces
(Using PostgreSQL-7.3.1)

I noticed that the new ~/.pgpass password file works with psql but not with
my pgtclsh scripts, and I'm wondering: shouldn't it work with anything
built on top of libpq?

Digging into it a bit, I think no conninfo-based connection method will use
.pgpass, including libpq PQconnectDB() and libpgtcl "pg_connect -conninfo".
I think it is happening because .pgpass is only read if the password
argument to PQsetdbLogin() is NULL. But if no password is supplied in a
conninfo string, then "DefaultPassword" is used - this is an empty string,
not NULL. Am I right? Is this behavior wrong?


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: compiling 7.2.3 with tcl -- tcl.h
Next
From: Tom Lane
Date:
Subject: Re: Shouldn't .pgpass work with anything which uses libpq?