Re: Proposal : REINDEX xxx VERBOSE - Mailing 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