Re: Proposal : REINDEX xxx VERBOSE

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
Cc: Fabrízio Mello <fabriziomello(at)gmail(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal : REINDEX xxx VERBOSE
Date: 2015-04-09 04:14:24
Message-ID: CAHGQGwHCuu4VWP0ch0Zh1Pr7f1BCUWfazzoVmjJ852X7Un7ZMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 8, 2015 at 10:53 PM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> wrote:
> On Wed, Apr 8, 2015 at 1:09 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> On Wed, Apr 8, 2015 at 1:57 AM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> wrote:
>>> On Wed, Apr 8, 2015 at 1:11 AM, Fabrízio de Royes Mello
>>> <fabriziomello(at)gmail(dot)com> wrote:
>>>>
>>>> On Tue, Apr 7, 2015 at 1:04 PM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
>>>> wrote:
>>>>>
>>>>> On Tue, Apr 7, 2015 at 10:12 PM, Fabrízio de Royes Mello
>>>>> <fabriziomello(at)gmail(dot)com> wrote:
>>>>> >
>>>>> > On Tue, Apr 7, 2015 at 7:22 AM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
>>>>> > wrote:
>>>>> >>
>>>>> >> Thank you for your reviewing.
>>>>> >> I modified the patch and attached latest version patch(v7).
>>>>> >> Please have a look it.
>>>>> >>
>>>>> >
>>>>> > Looks good to me. Attached patch (v8) just fix a tab indentation in
>>>>> > gram.y.
>>>>> >
>>>>>
>>>>> I had forgotten fix a tab indentation, sorry.
>>>>> Thank you for reviewing!
>>>>> It looks good to me too.
>>>>> Can this patch be marked as "Ready for Committer"?
>>>>>
>>>>
>>>> +1
>>>>
>>>
>>> Changed status to "Ready for Committer".
>>
>> The patch adds new syntax like "REINDEX ... WITH VERBOSE", i.e., () is not
>> added after WITH clause. Did we reach the consensus about this syntax?
>> The last email from Robert just makes me think that () should be added
>> into the syntax.
>>
>
> Thank you for taking time for this patch!

I removed the FORCE option from REINDEX, so you would need to update the patch.

> This was quite complicated issue since we already have a lot of style
> command currently.
> We can think many of style from various perspective: kind of DDL, new
> or old command, maintenance command. And each command has each its
> story.
> I believe we have reached the consensus with this style at least once
> (please see previous discussion), but we might needs to discuss
> more...

Okay, another question is that; WITH must be required whenever the options
are specified? Or should it be abbreviatable?

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2015-04-09 06:18:20 Re: Failure to coerce unknown type to specific type
Previous Message Etsuro Fujita 2015-04-09 03:07:11 Re: EvalPlanQual behaves oddly for FDW queries involving system columns