> > What bothers me about what we have now is that we have optional
> > keywords before and after INDEX, rather than only between
> CREATE and INDEX.
>
> Yeah, putting them both into that space seems consistent to
> me, and it will fix the problem of making an omitted index
> name look like a valid command.
>
> I'm not sure I should be opening this can of worms, but do we
> want to use a different keyword than CONCURRENTLY to make it
> read better there?
precedent syntax (Oracle, Informix) uses the keyword ONLINE at the end:CREATE INDEX blabla_x0 ON blabla (a,b) ONLINE;
I'd stick with that.
Andreas