Tom Lane wrote: > Peter Eisentraut <pete...@gmx.net> writes: > >> Could we create an option to create index names automatically, so you'd > >> only have to write > > >> CREATE INDEX ON foo (a); > > >> which would pick a name like foo_a_idx. > > Having done all the groundwork to support that nicely, I find that it > doesn't work because of bison limitations :-(. AFAICT, the only way > we could support this syntax would be to make ON a reserved word. > Or at least more reserved than it is now. We used up all the wiggle > room we had by making CONCURRENTLY non-reserved.
And here's Simon talking about making CONCURRENTLY more reserved so that people stop creating indexes named "concurrently" ... http://database-explorer.blogspot.com/2009/09/create-index-concurrently.html -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers