Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method') - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')
Date
Msg-id CAB7nPqS+JOB8HjK9iFQ868KszosFjFtiNYO_X2h5EqR5ZpQfqQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: CREATE/ALTER ROLE PASSWORD ('value' USING 'method')  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
On Fri, Mar 17, 2017 at 2:30 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Thu, Mar 9, 2017 at 4:59 AM, Michael Paquier <michael.paquier@gmail.com>
> wrote:
>>
>> On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway <mail@joeconway.com> wrote:
>> > On 03/07/2017 08:29 PM, Tom Lane wrote:
>> >> Michael Paquier <michael.paquier@gmail.com> writes:
>> >>> here is a separate thread dedicated to the following extension for
>> >>> CREATE/ALTER ROLE: PASSWORD ('value' USING 'method').
>> >>
>> >> The parentheses seem weird ... do we really need those?
>> >
>> > +1
>>
>> Seeing 3 opinions in favor of that, let's do so then. I have updated
>> the patch to not use parenthesis.
>
> The regression tests only exercise the CREATE ROLE...USING version, not the
> ALTER ROLE...USING version.

Done.

> +        and <literal>plain</> for an non-hashed password.  If the password
> +        string is already in MD5-hashed or SCRAM-hashed, then it is
> +        stored hashed as-is.
>
> In the last line, I think "stored as-is" sounds better.

Okay.

> Other than that, it looks good to me.

Thanks for the review. Attached is an updated patch.
-- 
Michael

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] increasing the default WAL segment size
Next
From: Corey Huinker
Date:
Subject: Re: [HACKERS] \if, \elseif, \else, \endif (was Re: PSQL commands:\quit_if, \quit_unless)