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