Dmitriy Igrishin <dmitigr(at)gmail(dot)com> writes:
> 2012/7/24 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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?
regards, tom lane