Re: Add --{no-,}bypassrls flags to createuser

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: michael(at)paquier(dot)xyz
Cc: Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add --{no-,}bypassrls flags to createuser
Date: 2022-04-13 08:35:02
Message-ID: 20220413.173502.518232247235383609.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Wed, 13 Apr 2022 16:10:01 +0900, Michael Paquier <michael(at)paquier(dot)xyz> wrote in
> On Wed, Apr 13, 2022 at 03:46:25PM +0900, Kyotaro Horiguchi wrote:
> > It is sensible to rig createuser command with full capability of
> > CREATE ROLE is reasonable.
> >
> > Only --replication is added by commit 9b8aff8c19 (2010) since
> > 8ae0d476a9 (2005). BYPASSRLS and NOBYPASSRLS were introduced by
> > 491c029dbc (2014) but it seems to have forgotten to add the
> > corresponding createuser options.
> >
> > By a quick search, found a few other CREATE ROLE optinos that are not
> > supported by createuser.
>
> My question is: is BYPASSRLS common enough to justify having a switch
> to createuser? As the development cycle of 15 has just finished and
> that we are in feature freeze, you may want to hold on new patches for
> a bit. The next commit fest is planned for July.

I don't think there's a definitive criteria (other than feasibility)
for whether each CREATE ROLE option should have the correspondent
option in the createuser command. I don't see a clear reason why
createuser command should not have the option.

As far as schedules are concerned, I don't think this has anything to
do with 15.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2022-04-13 09:07:54 Re: Support logical replication of DDLs
Previous Message Masahiko Sawada 2022-04-13 08:10:27 Re: Column Filtering in Logical Replication