Skip site navigation (1) Skip section navigation (2)

Re: create index concurrently docs ...

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: James Robinson <jlrobins(at)socialserve(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: create index concurrently docs ...
Date: 2007-04-03 22:40:21
Message-ID: 200704032240.l33MeL423849@momjian.us (view raw or flat)
Thread:
Lists: pgsql-docs
We have added the documentation you requested --- attached.

---------------------------------------------------------------------------

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(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-docs by date

Next:From: David FetterDate: 2007-04-06 23:46:03
Subject: Fix misleading references to columns in GRANT/REVOKE summaries
Previous:From: Bruce MomjianDate: 2007-03-30 16:38:46
Subject: Re: [ADMIN] no verification of client certificate?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group