Dmitriy Igrishin <dmitigr@xxxxxxxxx> writes: > 2012/7/24 Tom Lane <tgl@xxxxxxxxxxxxx> >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general