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? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general