database.yml, postgresql and pgpass.conf conflicts

Hi,

I noticed that, on Windows at least, if I have a password set in the database.yml file for a database that I also have in my pgpass.conf file, the Rails adapter will die with a password authentication error. I don't seem to have this issue on Unix systems.

It's simple enough to solve - just comment out the password info in the database.yml file. I just wondered if there was a more generic solution (other than "don't do that"), or a way to improve the adapter so that it Does The Right Thing.

Regards,

Dan