Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-04-05 Thread Heikki Linnakangas
On 04/06/2017 08:33 AM, Noah Misch wrote: On Fri, Mar 17, 2017 at 10:10:59AM +0900, Michael Paquier wrote: On Fri, Mar 17, 2017 at 2:30 AM, Jeff Janes wrote: On Thu, Mar 9, 2017 at 4:59 AM, Michael Paquier wrote: On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway wrote: On 03/07/2017 08:29 PM, To

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-04-05 Thread Noah Misch
On Fri, Mar 17, 2017 at 10:10:59AM +0900, Michael Paquier wrote: > On Fri, Mar 17, 2017 at 2:30 AM, Jeff Janes wrote: > > On Thu, Mar 9, 2017 at 4:59 AM, Michael Paquier > > wrote: > >> > >> On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway wrote: > >> > On 03/07/2017 08:29 PM, Tom Lane wrote: > >> >>

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-16 Thread Michael Paquier
On Fri, Mar 17, 2017 at 2:30 AM, Jeff Janes wrote: > On Thu, Mar 9, 2017 at 4:59 AM, Michael Paquier > wrote: >> >> On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway wrote: >> > On 03/07/2017 08:29 PM, Tom Lane wrote: >> >> Michael Paquier writes: >> >>> here is a separate thread dedicated to the foll

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-16 Thread Jeff Janes
On Thu, Mar 9, 2017 at 4:59 AM, Michael Paquier wrote: > On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway wrote: > > On 03/07/2017 08:29 PM, Tom Lane wrote: > >> Michael Paquier writes: > >>> here is a separate thread dedicated to the following extension for > >>> CREATE/ALTER ROLE: PASSWORD ('value'

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-09 Thread Michael Paquier
On Fri, Mar 10, 2017 at 12:00 AM, Joe Conway wrote: > On 03/09/2017 06:34 AM, Robert Haas wrote: >> On Thu, Mar 9, 2017 at 7:59 AM, Michael Paquier >> wrote: >>> Yes, I agree with that for MD5, and after looking around I can see >>> (like here http://prosody.im/doc/plain_or_hashed) as well that >

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-09 Thread Joe Conway
On 03/09/2017 06:34 AM, Robert Haas wrote: > On Thu, Mar 9, 2017 at 7:59 AM, Michael Paquier > wrote: >> Yes, I agree with that for MD5, and after looking around I can see >> (like here http://prosody.im/doc/plain_or_hashed) as well that >> SCRAM-hashed is used. Now, there are as well references t

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-09 Thread Robert Haas
On Thu, Mar 9, 2017 at 7:59 AM, Michael Paquier wrote: > Yes, I agree with that for MD5, and after looking around I can see > (like here http://prosody.im/doc/plain_or_hashed) as well that > SCRAM-hashed is used. Now, there are as well references to the salt, > like in protocol.sgml: > "The salt t

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-09 Thread Michael Paquier
On Thu, Mar 9, 2017 at 1:17 AM, Joe Conway wrote: > On 03/07/2017 08:29 PM, Tom Lane wrote: >> Michael Paquier 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

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-08 Thread Joe Conway
On 03/07/2017 08:29 PM, Tom Lane wrote: > Michael Paquier 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 > +If you do not plan to use pa

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-07 Thread Michael Paquier
On Wed, Mar 8, 2017 at 2:32 PM, Rushabh Lathia wrote: > One quick comments: > > +| PASSWORD '(' Sconst USING Sconst ')' > +{ > +$$ = makeDefElem("methodPassword", > + (Node *)list_make2(makeString($3), > +

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-07 Thread Rushabh Lathia
On Wed, Mar 8, 2017 at 9:59 AM, Tom Lane wrote: > Michael Paquier 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 I had quick glance to patc

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-07 Thread Michael Paquier
On Wed, Mar 8, 2017 at 1:29 PM, Tom Lane wrote: > Michael Paquier 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? A grammar without parenthesis works

Re: [HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-07 Thread Tom Lane
Michael Paquier 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? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-

[HACKERS] CREATE/ALTER ROLE PASSWORD ('value' USING 'method')

2017-03-07 Thread Michael Paquier
Hi all, As discussed on the thread dedicated to SCRAM (https://www.postgresql.org/message-id/243d8c11-6149-a4bb-0909-136992f74...@iki.fi), here is a separate thread dedicated to the following extension for CREATE/ALTER ROLE: PASSWORD ('value' USING 'method'). Now that password_encryption has been