2012/7/24 Tom Lane <t...@sss.pgh.pa.us> > Dmitriy Igrishin <dmit...@gmail.com> writes: > > 2012/7/24 Tom Lane <t...@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?
-- // Dmitriy.