Postgres Pro
Downloads
Home   >   mailing lists

Re: Roles with empty password (probably bug in libpq and in psql as well). - Mailing list pgsql-general

From Tom Lane
Subject Re: Roles with empty password (probably bug in libpq and in psql as well).
Date
Msg-id 23122.1343146454@sss.pgh.pa.us
Whole thread Raw
In response to Re: Roles with empty password (probably bug in libpq and in psql as well).  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: Roles with empty password (probably bug in libpq and in psql as well).
List pgsql-general
Tree view 
Dmitriy Igrishin <dmitigr@gmail.com> writes:
> 2012/7/24 Tom Lane <tgl@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

pgsql-general by date:

Previous
From: Mark Wynter
Date:
Subject: Problem using a pl/pgsql function to populate a geometry column with x,y data
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Roles with empty password (probably bug in libpq and in psql as well).