Re: Proposal : REINDEX xxx VERBOSE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal : REINDEX xxx VERBOSE
Date
Msg-id 21643.1423028677@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal : REINDEX xxx VERBOSE  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Proposal : REINDEX xxx VERBOSE
List pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 2/3/15 5:08 PM, Tom Lane wrote:
>> Jim Nasby <Jim.Nasby@bluetreble.com> writes:
>>> VACUUM puts the options before the table name, so ISTM it'd be best to
>>> keep that with REINDEX. Either REINDEX (options) {INDEX | ...} or
>>> REINDEX {INDEX | ...} (options).

>> Well, I really really don't like the first of those.  IMO the command name
>> is "REINDEX INDEX" etc, so sticking something in the middle of that is
>> bogus.

> Actually, is there a reason we can't just accept all 3? Forcing people 
> to remember exact ordering of options has always struck me as silly.

And that's an even worse idea.  Useless "flexibility" in syntax tends to
lead to unfortunate consequences like having to reserve keywords.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Proposal : REINDEX xxx VERBOSE
Next
From: Jim Nasby
Date:
Subject: Re: Table description in the data file (Re: pg_rawdump)