Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0EF539FB270 for ; Sat, 3 Feb 2007 21:28:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 31519-07 for ; Sat, 3 Feb 2007 21:28:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 1AB739FA18C for ; Sat, 3 Feb 2007 21:28:09 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l141Rhk17779; Sat, 3 Feb 2007 20:27:43 -0500 (EST) From: Bruce Momjian Message-Id: <200702040127.l141Rhk17779@momjian.us> Subject: Re: create index concurrently docs ... In-Reply-To: <5F277D5E-DB72-4BA1-9DFA-175FB749FB21@socialserve.com> To: James Robinson Date: Sat, 3 Feb 2007 20:27:43 -0500 (EST) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/2 X-Sequence-Number: 4133 Does anyone know the answer to this? I couldn't find it, but it is a good quesiton. --------------------------------------------------------------------------- James Robinson wrote: > In reading over the caveats regarding create index concurrently, I > think it'd be nice to see an example of what the return result will > be if an 'invalid' index is created so a dba who read the docs night > recognize the error, as well as for searchengine fodder to find out > what to do real fast if such an error happens to them. > > Something around this paragraph in http://www.postgresql.org/docs/ > current/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY: > > "If a problem arises during the second scan of the table, such as a > uniqueness violation in a unique index, the CREATE INDEX command will > fail but leave behind an "invalid" index." > > Thanks! > ---- > James Robinson > Socialserve.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +