Hello > I don't want a situation like this: > CREATE INDEX CONCURRENTLY ... > DROP INDEX CONCURRENTLY ... > REINDEX INDEX (CONCURRENTLY) ... > > All three should be the same, and my suggestion is to add the > parenthesized version to CREATE and DROP and not add the unparenthesized > version to REINDEX.
We already have parenthesized VERBOSE option for REINDEX. So proposed syntax was: REINDEX (CONCURRENTLY) INDEX ... REINDEX (VERBOSE, CONCURRENTLY) INDEX ... Like parameters for EXPLAIN, VACUUM. And completely unlike create/drop index. So consistent syntax for create/drop would be: CREATE (CONCURRENTLY) INDEX ... CREATE (UNIQUE, CONCURRENTLY) INDEX ... # or we want parenthesized concurrently, but not unique? CREATE UNIQUE (CONCURRENTLY) INDEX? DROP (CONCURRENTLY) INDEX ... How about REFRESH MATERIALIZED VIEW? Do not change? regards, Sergei