> 2012/7/24 Tom Lane <tgl@sss.pgh.pa.us> >> Please note that empty and null are not the same thing...
> Yes, I know. But why the ALTER ROLE treats '' as NULL and > as the result all of values of pg_catalog.pg_authid.rolpassword are always > NULL even when the password in ALTER ROLE was specified as ''? :-)
It does not do that for me. What PG version are you testing?
Oops, I am sorry, Tom. It doesn't on my 9.2beta2. Perhaps, it's too hot in Russia now... But maybe it's worth it to add a parameter key word to libpq, e.g. "passwd" which's empty value will be treated as an empty password?