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

From serovov+pgsql@gmail.com
Subject BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing
Date
Msg-id E1TLVTt-0000G1-FV@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7589
Logged by:          Oleg
Email address:      serovov+pgsql@gmail.com
PostgreSQL version: 9.1.6
Operating system:   CentOs
Description:        =


See sql console: =


01=3D# CREATE UNIQUE INDEX CONCURRENTLY obj_pkey ON obj (id);
ERROR:  canceling statement due to statement timeout
01=3D# CREATE UNIQUE INDEX CONCURRENTLY obj_pkey ON obj (id);
01=3D# CREATE UNIQUE INDEX CONCURRENTLY obj_pkey ON obj (id);
ERROR:  relation "obj_pkey" already exists
01=3D# SELECT version();
PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)

pgsql-bugs by date:

Previous
From: hrtlik@gmail.com
Date:
Subject: BUG #7590: Data corruption using pg_dump only with -Z parameter
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] BUG #7534: walreceiver takes long time to detect n/w breakdown