Re: Tricky bugs in concurrent index build

Zeugswetter Andreas DCP SD wrote:
> 
> > > 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;

That was what the patch originally used, but it was changed because it
made difficult for psql to auto-complete that.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.