Dave Page <[EMAIL PROTECTED]> writes:
> Just to add a note to that - when running it in the same shell from
> which I started the server with messages going to stdout, it seemed
> clear that it trys to connect once using PGPASSWORD, then when that
> fails, it prompts for the password instead, and then tries to connect
> with that and fails a second time.
Hmmm ... it seems the problem is that we've defined
PQconnectionUsedPassword in such a way that it returns true (causing a
prompt) regardless of whether the reason for the connection failure was
a bad password or not. We might need to reconsider that API.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
