Tom Lane writes:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > But if you have different passwords between databases then you are still
> > having the same problem, only at a different scale.
>
> ... which we do not have, at the moment; there's one password per user
> per installation,
No, pg_hba.conf allows per database passwords.
> In any case, isn't psql's logic such that it will prompt again if the
> previous password doesn't work?
No, it will only prompt you for a password if it notices one is required.
If that's wrong the connection attempt fails and you can try again (to
connect). That's reasonable enough I think.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
