postgresql 7 user passwords dont work ?????

users dont seem to need password in postgres 7 on red hat linux
6.2, compiled from source.

I do an:

alter user nsadmin with password 'whatever';

And then when I do an:

psql -u -d mydb

username: nsadmin password: NOTwhatever

IT STILL LETS ME IN ????

This should not be so should it ?

please advise, thanks

streethockey(at)ureach(dot)com

________________________________________________
Get your own "800" number - Free
Free voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag