• Tom Lane's avatar
    Allow the index name to be omitted in CREATE INDEX, causing the system to · d68e08d1
    Tom Lane authored
    choose an index name the same as it would do for an unnamed index constraint.
    (My recent changes to the index naming logic have helped to ensure that this
    will be a reasonable choice.)  Per a suggestion from Peter.
    
    A necessary side-effect is to promote CONCURRENTLY to type_func_name_keyword
    status, ie, it can't be a table/column/index name anymore unless quoted.
    This is not all bad, since we have heard more than once of people typing
    CREATE INDEX CONCURRENTLY ON foo (...) and getting a normal index build of
    an index named "concurrently", which was not what they wanted.  Now this
    syntax will result in a concurrent build of an index with system-chosen
    name; which they can rename afterwards if they want something else.
    d68e08d1
create_index.sgml 22 KB