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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: serovov+pgsql(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing
Date: 2012-10-09 18:28:48
Message-ID: 2170.1349807328@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

serovov+pgsql(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-10-09 18:34:27 Re: BUG #7591: Large query string has limit
Previous Message pking 2012-10-09 15:24:23 BUG #7591: Large query string has limit