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: (view raw, whole thread or download thread mbox)
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 
> 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
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + 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-2017 The PostgreSQL Global Development Group