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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing
Дата
Msg-id 2170.1349807328@sss.pgh.pa.us
обсуждение
Ответ на BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing  (serovov+pgsql@gmail.com)
Список 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

В списке pgsql-bugs по дате отправления: