2012/7/24 Tom Lane
> Dmitriy Igrishin writes:
> > 2012/7/24 Tom Lane
> >> 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
Dmitriy Igrishin writes:
> 2012/7/24 Tom Lane
>> 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 spec
2012/7/24 Tom Lane
> Dmitriy Igrishin writes:
> > But it's impossible to pass empty (NULL) password to the backend
>
> 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.rolpass
Dmitriy Igrishin writes:
> But it's impossible to pass empty (NULL) password to the backend
Please note that empty and null are not the same thing...
> by using libpq, because connectOptions2() defined the
> fe-connect.c reads a password from the ~/.pgpass even when a password
> specified as an
On 07/24/2012 05:41 AM, Dmitriy Igrishin wrote:
Hey all,
According to http://www.postgresql.org/docs/9.2/static/sql-alterrole.html
A query:
ALTER ROLE davide WITH PASSWORD NULL;
removes a role's password.
http://www.postgresql.org/docs/9.2/static/sql-createrole.html
PASSWORD password
Sets the
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dmitriy Igrishin
Sent: Tuesday, July 24, 2012 10:00 AM
To: Guillaume Lelarge
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Roles with empty password (probably bug in libpq and in
psql as
2012/7/24 Dmitriy Igrishin
>
>
> 2012/7/24 Guillaume Lelarge
>
>> On Tue, 2012-07-24 at 17:36 +0400, Dmitriy Igrishin wrote:
>> > Hey Guillaume,
>> >
>> > 2012/7/24 Guillaume Lelarge
>> > On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote:
>> > > Hey all,
>> > >
>
2012/7/24 Guillaume Lelarge
> On Tue, 2012-07-24 at 17:36 +0400, Dmitriy Igrishin wrote:
> > Hey Guillaume,
> >
> > 2012/7/24 Guillaume Lelarge
> > On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote:
> > > Hey all,
> > >
> > > According to
> > http:
On Tue, 2012-07-24 at 17:36 +0400, Dmitriy Igrishin wrote:
> Hey Guillaume,
>
> 2012/7/24 Guillaume Lelarge
> On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote:
> > Hey all,
> >
> > According to
> http://www.postgresql.org/docs/9.2/static/sql-alterr
Hey Guillaume,
2012/7/24 Guillaume Lelarge
> On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote:
> > Hey all,
> >
> > According to
> http://www.postgresql.org/docs/9.2/static/sql-alterrole.html
> >
> > A query:
> > ALTER ROLE davide WITH PASSWORD NULL;
> > removes a role's password.
> >
>
On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote:
> Hey all,
>
> According to http://www.postgresql.org/docs/9.2/static/sql-alterrole.html
>
> A query:
> ALTER ROLE davide WITH PASSWORD NULL;
> removes a role's password.
>
> But it's impossible to pass empty (NULL) password to the backe
11 matches
Mail list logo
