Re: Roles with empty password (probably bug in libpq and in psql as well).

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-general(at)postgresql(dot)org
Subject: Re: Roles with empty password (probably bug in libpq and in psql as well).
Date: 2012-07-24 16:14:14
Message-ID: 23122.1343146454@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2012-07-24 16:53:38 Re: Roles with empty password (probably bug in libpq and in psql as well).
Previous Message Dmitriy Igrishin 2012-07-24 14:48:02 Re: Roles with empty password (probably bug in libpq and in psql as well).