Re: new createuser option for replication role

Fujii Masao <masao.fujii@gmail.com>

From: Fujii Masao <masao.fujii@gmail.com>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-09-26T08:55:50Z
Lists: pgsql-hackers
On Fri, Sep 23, 2011 at 10:47 PM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> 2011/9/23 Robert Haas <robertmhaas@gmail.com>:
>> On Thu, Sep 22, 2011 at 12:45 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
>>> Agreed. Attached is the updated version of the patch. It adds two options
>>> --replication and --no-replication. If neither specified, neither REPLICATION
>>> nor NOREPLICATION is specified in CREATE ROLE, i.e., in this case,
>>> replication privilege is granted to only superuser.
>>
>> Committed.  Do we need to make any changes in interactive mode, when
>> we prompt?  In theory this could be either wanted or not wanted for
>> either superusers or non-superusers, but I'm not really sure it's
>> worth it, and I certainly don't want the command to go into
>> interactive mode just because neither --replication nor
>> --no-replication was specified.
>>
>> Thoughts?
>
> I believe the intereactive mode is useless.

Agreed. I think that a majority of "createuser" users are not interested
in REPLICATION privilege yet.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center