Re: creating index names automatically? - Mailing list pgsql-hackers

Peter Eisentraut <peter_e@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.

Now ON is reserved according to SQL99, but I'm a bit hesitant to
make it so in our grammar for such a marginal feature as this.
Thoughts?
        regards, tom lane