Re: BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing - Mailing list pgsql-bugs

serovov+pgsql@gmail.com writes:
> 01=# CREATE UNIQUE INDEX CONCURRENTLY obj_pkey ON obj (id);
> ERROR:  canceling statement due to statement timeout
> 01=# CREATE UNIQUE INDEX CONCURRENTLY obj_pkey ON obj (id);
> ERROR:  relation "obj_pkey" already exists

This is not a bug, it is the documented failure behavior of CREATE INDEX
CONCURRENTLY.  See
http://www.postgresql.org/docs/9.2/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY

            regards, tom lane